Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Changing time hh:mm:ss field

    I’m currently working on time (hh:mm:ss) field.

    I currently have 3 fields: -

    Time Out (populated)
    Time In (populated)
    Total Time (empty)

    The Total Time field is worked out by Time Out less (minus) Time In.

    =SUM(AZ2-AW2)

    I’ve noticed that when the time goes over the 24hr (12pm) I get an error, so I use the following

    =SUM(AZ2-AW2)+1

    What I need is to show it in hours – i.e. “04:15:00” should be shown as 4.25 hours

    Is this possible? And how?

    Thanks in advance

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Quote Originally Posted by akhlaq768
    I’m currently working on time (hh:mm:ss) field.

    I currently have 3 fields: -

    Time Out (populated)
    Time In (populated)
    Total Time (empty)

    The Total Time field is worked out by Time Out less (minus) Time In.

    =SUM(AZ2-AW2)

    I’ve noticed that when the time goes over the 24hr (12pm) I get an error, so I use the following

    =SUM(AZ2-AW2)+1

    What I need is to show it in hours – i.e. “04:15:00” should be shown as 4.25 hours

    Is this possible? And how?

    Thanks in advance
    Hi

    On the basis that if AZ is always the next day if it is before AW (ie not the day after or day before !?) then try this

    =(AZ2-AW2+IF(AZ2<AW2,1,0))*24

    The cell with this formula should be formatted as a number (2 dec places)

    HTH


    MTB

Posting Permissions

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