One way:
XL stores times as fractional days, so if you're adding A1:A10:
Hours:Minutes display:
=SUM(A1:A10)
then Format/Cells/Number/Custom [h]:mm
decimal hours:
=SUM(A1:A10)*24
In article ,
"Kjell" wrote:
Hi
I need to sum up a column displaying time (4:00 or 6:30) but display the
sum as decimal......?!?!?!
or at least get the answer in Hours:minutes even if Hours 24 ....?!??!
I can do this in VB and other soft but can I do it in Excel directly???
Kjell