+ Reply to Thread
Results 1 to 2 of 2

Convert Time to decimel

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    UK
    Posts
    1

    Convert Time to decimel

    I am trying to convert a number of hours in format hours:minutes:seconds in to a decimel number. I have found a formula in excel help, but it doesn't work when the total time is over 24 hours.
    I am adding up number of hours worked over a week, so totals can be upwards of 48, eg 48:15:00 and for salary purposes i want to convert this to 48.25 hours.
    Help appreciated.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531
    multiply the time value by 24 and format to general

    if A1 holds 48:15:00 then B1: =A1*24

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1