Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Kankakee, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 (2000)

    I am trying to create a formula that totals the number of hours worked in a week. However, since the daily numbers and totals are formated as time (hh:mm), the totals roll over after 24 hours. This means that when a total should read 39:30, it will only show 15:30. How do I make the formula show the true number of hours worked?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (2000)

    Linda,

    Format the cell as [hh]:mm
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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