MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Problem calculating time


Posted by Frits Jager on November 20, 2001 2:55 AM


Hello,


I'm having a little problem calculating time.

I have entered the following informating in an Excel sheet.

A1 = 12:00:00
A2 = 12:00:00
A3 = 1:00:00
A4 = 0:45:00

In cel A6 these values are added, with the formula
=SUM(A1:A4).
So the value 25:45:00 is displayed in cel A6.

All cells are defined as "Time" (Hours:Minutes:Seconds)

What I want to do next, is the following.

I would like the time being displayed as decimal values in cel A8.
So 25:45:00 should become 25,75 in decimal notation.

Can anyone help me how to do this ?

Thanks.... :-)

Frits Jager


Posted by Mudface on November 20, 2001 3:22 AM

Try =SUM(A1:A4)*24 and format cell as General or Number to 2 decimal places.

Posted by Frits Jager on November 20, 2001 3:31 AM


Hello,

It works !!
Great !!
Thank you very much !!


Best regards,

Frits Jager