calculating hours worked function PLEASE! beg beg

  • Thread starter Thread starter VødkäJéllÿ
  • Start date Start date
V

VødkäJéllÿ

Please could someone help :O)

if I have the 23:00 in one cell and 07:40 in another, what is the formula to
work out the hours worked?

I used to know it, but alas my poor brain has misplaced the answer.

Cheers group

Vj
 
JS said:
this formula will calc difference in time

=B2-A2+IF(A2>B2,1)

where A2 = start time and B2 = end time
format the cell you enter this formula into as hh:mm
Click to expand...
ok that worked v well :O) thing is the totals come up in hours and minutes
and we need them as hours and fractions ie;
10 1/2 not 10:30

I tried setting the cell to fraction but that didn't work and i tried *24
but that didn't work either!

back to the drawing board!

Vj
 
Try

=ROUND(B2-A2+(A2>B2)*24,2)

format result as general, the if part is not really necessary
 
Back
Top