Working out hours
 

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!!!!

Working out hours
 

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



"Nicola22" wrote:

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!!!!

Working out hours
 

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

On Mar 3, 11:42*am, "Nicola22" <u50053@uwe wrote:
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!!!!