Excel Formula/Function for Calculating Hours

westendgirlie

Hiya,

I've created a timesheet spreadsheet for my boyfriend so all he has to do is enter the hours each day and it will compute his net pay. It all works perfectly.

Want I want to try and do now is let him enter the times he starts and finishes and let excel work out how many hours that is. ie; Column A = start time (8am) Column B = finish time (6pm) Column C would be hours worked. Bear in mind times worked will vary.

Can any of you smarties in 'ere help me?

5uspect

Just enter the time in the correct format, such as 24hr, and Excel will automatically handle it.

So cell A1 is 9:00 and cell B1 is 17:00.
I've set the formatting "hh:mm AM/PM"

westendgirlie

Thanks but it's still not working as I would like.

a(start),b(finish),c(hours less 45 min break) = Mon
d(start),e(finish),f(hours less 45 min break) = Tue
g(start),h(finish),i(hours less 45 min break) = Wed
j(start),k(finish),l(hours less 45 min break) = Thu
m(start),n(finish),o(hours less 45 min break) = Fri

P = total hrs
Q = hrly rate
R = gross pay

the total hrs give me a random figure even when I leave out 45 min break

Dulchie

You might like to try

http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html

This is zip file containing a variety of timesheet types and if free for personal use

westendgirlie

Cheers guys.

Copied and pasted formula from one of the zip files and amended accordingly.

paulgalway

more Templates here