Time Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
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
Click to expand...
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
 
I'm sorry but I don't get it! Could you be a little more specific about cell-fomat etc. Thanks in advance!
 
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
 
Back
Top