Kjell,
For 24 hours, just format the cell as [h]:mm, and add up as normal.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Kjell" wrote in message
...
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