Time Calculation

[Kajo]

I've got a problem with calculating time. Let's say I've got the worked time to 2 hours and 15 minutes. That means in decimals 2,25. How do I get excel to calculate this? (Both ways; from hours, minutes to decimals and from decimals to hours, minutes. I don't put in start and end time, I just put in the numbers. We are in the stoneage here so I've got Excel97. Please help!!!

 

[Andy Brown]

I've got a problem with calculating time. Let's say I've got the worked
time to 2 hours and

15 minutes. That means in decimals 2,25. How do I get excel to calculate

this?

In Excel, 1 day = 1. Therefore, 1 hour = 1/24. So use e.g.

=A1*24

or

=B1/24

, the latter formatted time-style (paste the format from A1).

Rgds,
Andy

 

[Kajo]

I'm sorry but I don't get it! Could you be a little more specific about cell-fomat etc. Thanks in advance!

 

[Andy Brown]

I'm sorry but I don't get it! Could you be a little more specific about
cell-fomat etc. Thanks in advance!

Ignore the quotes ("") throughout the following. Say you enter "2:15" (2
hours 15 minutes) in A1. Then enter

=A1*24

in B1. The result may display as "06:00" ; if so, Format -- Cells -- Number
; category = Number, 2 DPs, OK. To go the other way, in C1

=B1/24

The result may display as "0.09375" ; if so, use the Format Painter tool to
copy the format from A1 to C1.

Rgds,
Andy

 

[Kajo]

Thank you for your time
It worked out just fine

Kajo