Results 1 to 4 of 4

Convert Hours to Fractions of Hours

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2009
    Location
    Seattle, WA (USA)
    MS-Off Ver
    Excel 2007
    Posts
    8

    Convert Hours to Fractions of Hours

    Greetings again,

    I am attempting to convert a spreadsheet of times (listed in the format 06:15:39.62, where 06 is the hour, 15 is the minutes, 39 is the seconds, and .62 is in truncated miliseconds) into fractions of hours (so, 6.25 [NOT 6:25!]). I've so far been doing it manually for each value, which is quite tedious (doing basic division of seconds and minutes into hours, to find the fraction) but I'd like a single formula which I can then apply to the whole spreadsheet.

    Unfortunately, I am at a total loss as to how to do this. Any help is appreciated.
    Last edited by Munificent K. Factor; 05-28-2009 at 05:54 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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