Working out hours

N

Nicola22

Please help me urgently!

Im currently working for a big company & have loads of timesheets to work out
manually but i want to set up a spreadsheet to make it easier & quicker.
I have tried using the formula =sum(C2-B2)*24 but it does not work.
Does anyone have any ideas on how to do this!!!!
 
M

Mike H

Nicola,

It would have helpded enormously if you had told us what is in B2 & C2 but
given you didn't I'll guess they are times. Try this and I assume the C2 is
the later time

=(C2-B2)*24

Now the important bit, format the cell as General.

Mike
 
P

Pete_UK

If you want help urgently then you should give responders something to
go on. What does "it does not work" mean? Are you getting errors,
wrong values etc?

Describe how your data is laid out (columns used, sheetnames etc) and
what you want to do with it.

Pete
 
Top