Converting Time (HH:MM:SS) to Number for Summaries
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.
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
------------------------------
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 |
Many Thanks,
Al
------------------------------
Al Rice
Owner - President- CEO
Trends In Data, LLC
West Bloomfield MI
(248) 761-5238
------------------------------
No comments on this post.