Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: adding hours and minutes in decimal

    Hi Guys,

    Im trying to add hours and minutes by means of decimals

    i.e

    1.30 = 1 hour 30 mins
    2.30 = 2 hours 30 mins

    total = 4 hours

    I know you can use the hh:mm format however i need to enter the times in decimal format.

    any ideas?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    1.5 = 1 hour 30 minutes
    2.5 = 2 hours 30 minutes
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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