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