Excel help needed

[Mint_Sauce]

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

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

 

[Tomsk]

column A = start times
column B = end times
column C = hours

formulas in C "Bx-Ax+IF(Bx<Ax,1,0)"

at the bottom of column C "sum(C1:Cn)"
change format of this total to "[h]:mm"

 

[Fireblade2K4]

Probably the easiest way to do this is to enter the start time and end time with the days date also.

30/09/2006 20:00:00

Format all the cells to "Time"

So in the columns you should then have:-

Start = A
End = B
Hours = C

Then in the column where you want to calculate the hours just enter this formula =B-A

This will calculate the hours for you.

Stu

 

[Mint_Sauce]

Cool, thanks!

I'll give it a go tomorrow, need sleep.