Converting Time (HH:MM:SS) to Number for Summaries

User: "Al_22614"
Altair Community Member
Updated by Al_22614
Hello All... Again:

I want to use Time Values  in A Summary where the Time Values are Measures  Across Columns by "Day".  I believe I need to convert the Time Values to Numbers, and then Export the Summary to Excel where I can then define the Numeric values to "Time" to Show the Report in the format below.
Activity Activity Time Day 1 Day 2 Day 3
Activity 1 8:30 AM 8:30 AM   8:30 AM
Activity 1 8:35 AM   8:35 AM  
Activity 2 9:00 AM 9:00 AM    
Activity 2 9:01 AM   9:01 AM 9:01 AM
Activity 3 10:01 AM 10:01 AM    
Activity 3 10:10 AM   10:10 AM  
Activity 3 8:30 AM     8:30 AM
Can anyone help with this?  I know other ways to do this in Excel, but I want to get maximum calculations in Monarch Classic before exporting to Excel.

Many Thanks,
Al



------------------------------
Al Rice
Owner - President- CEO
Trends In Data, LLC
West Bloomfield MI
(248) 761-5238
------------------------------

Find more posts tagged with

No comments on this post.