Time Computation

[Guest]

I have three columns in my workbook as follows:

Arrival Time 21:24:00
Departure Time 21:35:00
Diff 0:11

When I try to sum the Diff column which is in same format as AT and DT, I
get some off the wall number that comes nowhere close to the number of HH:MMs
represented in the Diff column.

Can someone help me with the formula or whatever it takes to computer the
Diff column total?

Thanks in advance.

KP

 

[Guest]

Format the SUM cell as [HH]:MM

HTH

 

[Guest]

The diffference is in days wit a fraction. Using the menu option Format
cells number you can select different option. Use data HH:MM if this is
whatt you wnat.

You can always convert days to hours - minutes to a sting witth

=text(mytime/24)+":"+text(mod(mytime,24))