Excel help needed

Soldato
Joined
25 Sep 2003
Posts
3,750
Location
Manchester
I've done some work, logging the time started and the time finished and now need to add up those times to work out the amount of hours i've worked.

here's a tiny snapshot so you can see what i'm trying to do

Code:
start    end      hours
20:00	22:30	2.50 (easy to manually add up)
22:12	01:42	???!
19:24	20:47   ??!?

Can excel takes time differences and convert them to hours? I need to do this so I can then add up the hours column and then do a simple calculation on the final hours and the amount I charge per hour, giving me the total.

Thanks to any excel gurus out there :)
 
Back
Top Bottom