Excel formula help please

TheMagicPirate · 21 May 2008 at 13:42

Hey all,
I'm finally creating an Excel spreadsheet to keep track of my hours at work but I'm stuck with one of the formula's (formulae sp?)

I want to enter my start time in A1 and my end time in B1 and for C1 to figure out how many hours (in decimal) I have worked. I just cant seem to figure out a formula for it to do this?

If anyone could help I'd love you long time

Thanks

davethe11 · 21 May 2008 at 13:44

have you formatted the cells with the times in at all?

TheMagicPirate · 21 May 2008 at 13:46

Cells A1 and B1 are formatted as time and C1 is number at the moment.

Time shown as 1:00PM/1:00AM

div0 · 21 May 2008 at 13:54

So long as you don't work night shift, this should give you what you want.

In C1:

=(B1-A1)*24

/edit - slightly more comprehensive, eg if you want to allow for overnight...

=IF((B1-A1)<0, (B1-A1+1)*24, (B1-A1)*24)

TheMagicPirate · 21 May 2008 at 13:57

Works perfectly mate.

Thanks very much!!

div0 · 21 May 2008 at 14:03

No probs, I added an edit a minute ago, just incase you need it to work for overnight shifts.

Glad to help