# Time formula for hours and minutes

Printable View

• 27th September 2007, 03:23 PM
timbo343
Time formula for hours and minutes
Does anyone know a formula to work out how long ive been at work? Am wanting to record my hours and see how many hours over im doing a week, but i just cant seem to get the hours and minutes formula. Say if i started work at 7:49 am and finished at 16:58, i would want excel to work out how many hours ive worked for. Thanks.
• 27th September 2007, 05:39 PM
mckeder
Re: Time formula for hours and minutes
Try

=(MAX(A1:B1)-MIN(A1:B1))*24

It worked for me.

Google.com search function FTW!
• 1st October 2007, 03:15 PM
m2d2
Re: Time formula for hours and minutes
Quote:

Originally Posted by mckeder
Try

=(MAX(A1:B1)-MIN(A1:B1))*24

It worked for me.

Google.com search function FTW!

Eh? What's wrong with just B1-A1? If you enter the time in hh:mm format then Excel should understand that it's dealing with time and do the correct type of maths.

Also don't forget to subtract time off for lunch, if people allow you to have lunch that is ;)
• 1st October 2007, 03:40 PM
fooby
Re: Time formula for hours and minutes
If the cells are correctly formatted as Time, then m2d2 is correct in that you can use more conventional formula of =cell-othercell and such.

fooby
• 1st October 2007, 05:12 PM
mckeder
Re: Time formula for hours and minutes
=(MAX(A1:B1)-MIN(A1:B1))*24

The reason for that formula is because if he puts the time in either one, excel can still figure it out.

If you did A1-B1 and he put his clock in time in B1 and his end time in A1 then the formula wouldn't be the same and wouldn't give a correct amount of time.
• 1st October 2007, 05:55 PM
pmassingham
Re: Time formula for hours and minutes
Have a look at this. Should be self explanatory. Type in the Balance b/f, period and the start finish times and Bob's yer uncle!

You only have to adlust the period lookup table at the start of each year. Don't change anything else in the sheets apart from Title and School name! It will also print out the time sheet.