Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding time over 24 hours (excel 2007)

    I have a total column that gives me the difference of start time to end time. It is formatted as 13:30 in excel. I need to now add all the totals. I used to have a function that would add the total hours once is went over 24. I can't find it anymore. Can anyone help?

    Thanks,

    Mike

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding time over 24 hours (excel 2007)

    you need to changes the format of the cell (Ctrl+1) where is the total:

    <font color=red> [h]:mm </font color=red>

Posting Permissions

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