Time Computation
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
|