Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time conversion
Hi,
I have 3 columns in the workbook, 1 for start time, 1 for end time and last one is the difference. The difference I get is in the HH:MM:SS format. I need help in coverting this result into total minutes. E.g: Start End Total Time 17:58:51 20:44:21 2:45:30 The total time should then be converted into 165 minutes. Please help. Thanks, Aliya |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time conversion
multiply the difference by the number of minutes in a day, (1440) and
format the result as a number "aliya.pawaskar" wrote: Hi, I have 3 columns in the workbook, 1 for start time, 1 for end time and last one is the difference. The difference I get is in the HH:MM:SS format. I need help in coverting this result into total minutes. E.g: Start End Total Time 17:58:51 20:44:21 2:45:30 The total time should then be converted into 165 minutes. Please help. Thanks, Aliya |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time conversion
hi
you could apply a custom format to the total cell..... [MM]:ss regards FSt1 "aliya.pawaskar" wrote: Hi, I have 3 columns in the workbook, 1 for start time, 1 for end time and last one is the difference. The difference I get is in the HH:MM:SS format. I need help in coverting this result into total minutes. E.g: Start End Total Time 17:58:51 20:44:21 2:45:30 The total time should then be converted into 165 minutes. Please help. Thanks, Aliya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
time conversion | Excel Discussion (Misc queries) | |||
Time Conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Discussion (Misc queries) |