Summing Hours and Minutes

[Guest]

Hello,
I have a TIME ...I then subtract from it another TIME.
The first is formatted like 4:30 PM the second is formatted
like 10/5 5:00 PM. I then get the answer and I format it
using hh:mm so my answer may be 5:44 ...meaning
5 hours 44 minutes....
I try to take all the answers and get a sum and I get #####
I make the column wider...but its never wide enough so I suppose something
is wrong with my premise here.
Any help is greatly appreciated.
Ken

 

[Guest]

Hi,

Try the following formula in another cell,

=INT(B10*24)&" :
"&IF(LEN(ROUND(MOD(B10*24,1)*60,2))=1,"0"&ROUND(MOD(B10*24,1)*60,2),ROUND(MOD(B10*24,1)*60,2))

Change the 'B10's in the formula (there are four) to the cell address
showing the ###### in your spreadsheet.

Regards,
B. R. Ramachandran