Tracking Equipment Hours [h:m]

Hi there... and welcome to the Excel Forum. Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

There is a limit on the number of hours that Excel can cope with in the [h]:mm format. It is 10,000. To overcome this, you need a UDF (REMEMBER to enable macros when you open this file!!!:

Please Login or Register  to view this content.

Now when you enter those HUGE times, if you use: =Largetime(hours,minutes) and format the required cells as [h]:mm;@ everything works perfectly!!

Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.