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

Format the SUM cell as [HH]:MM

HTH

"KenP" wrote:

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

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))

"KenP" wrote:

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