Time sheet problem, help

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi all,
I have a time sheet to caculate wage. How do I convert the
time (hh:mm) to decimal. For example,

(A1) (B1) (B1-A1)
Time in, Time out, time worked
8:00, 12:30, 4:30

How do I convert 4:30 to 4.5 so that I could calculate
wage?

Thanks
 
XL stores times as fractional days (e.g., 03:00 is stored as 0.125),
so to convert times to integer hours, multiply by 24:

C1: =(B1-A1)*24

Note that if your time span goes past midnight, the "later" time
will be less than the "earlier" time (e.g., 9:00 pm = 0.875, so 3:00
- 9:00 = -0.75, not 0.25). To correct this either add 1 in that case
(taking advantage of the fact that XL converts TRUE to 1 and FALSE
to 0):

=((B1-A1)+(B1<A1))*24

or use the somewhat more obscure MOD function:

=MOD(B1-A1,1)*24
 
Hi all,
I have a time sheet to caculate wage. How do I convert the
time (hh:mm) to decimal. For example,

(A1) (B1) (B1-A1)
Time in, Time out, time worked
8:00, 12:30, 4:30

How do I convert 4:30 to 4.5 so that I could calculate
wage?

Thanks
Click to expand...

Excel stores times as fractions of a day. So to convert 4:30 to 4.5 multiply
by 24 (format as General or Number)


--ron
 
Back
Top