+ Reply to Thread
Results 1 to 2 of 2

How do I convert run time(45,502h 30m) to number 45,502.5 ??

  1. #1
    mgonzo
    Guest

    How do I convert run time(45,502h 30m) to number 45,502.5 ??

    Using Excel, i have a machine run time log ex 45,502hours 30minutes, how do i
    convert all values to number format (45,502.5)?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    If your run time is an actual time then to convert to decimal hours just multiply by 24 and format as a number - or is it text - in which case can you give the exact format

+ 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