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

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

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