+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Time formula for hours and minutes in Technical; Does anyone know a formula to work out how long ive been at work? Am wanting to record my hours ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,035
    Thank Post
    305
    Thanked 293 Times in 203 Posts
    Rep Power
    120

    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.

  2. #2

    Join Date
    Sep 2007
    Posts
    28
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Time formula for hours and minutes

    Try

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

    It worked for me.


    Google.com search function FTW!

  3. #3

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17

    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

  4. #4
    fooby's Avatar
    Join Date
    Dec 2005
    Posts
    351
    Thank Post
    0
    Thanked 5 Times in 4 Posts
    Rep Power
    19

    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

  5. #5

    Join Date
    Sep 2007
    Posts
    28
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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.

  6. #6

    Join Date
    Mar 2006
    Location
    Chelmsford
    Posts
    115
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    19

    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.
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. ICT Budget formula.
    By sLiDeR in forum Budgets and Expenditure
    Replies: 10
    Last Post: 23rd January 2008, 08:14 PM
  3. Waste 10 minutes and feed the world...
    By SpuffMonkey in forum Jokes/Interweb Things
    Replies: 4
    Last Post: 13th November 2007, 10:47 AM
  4. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  5. How much extra time do you put in out of hours?
    By beeswax in forum General Chat
    Replies: 12
    Last Post: 10th January 2006, 09:38 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •