Thread: Time conversion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aliya.pawaskar[_2_] aliya.pawaskar[_2_] is offline
external usenet poster
 
Posts: 6
Default 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