Adding up Time like decimal values ??
 

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

Adding up Time like decimal values ??
 

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

Adding up Time like decimal values ??
 

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