Is there a cool way to round up Custom [h]:mm;@ hours e.g. 55260:26 to 55261?
I have attached example with aircraft in column A, the exported value from AMOS in column B and the desired result in column C.
Is there a cool way to round up Custom [h]:mm;@ hours e.g. 55260:26 to 55261?
I have attached example with aircraft in column A, the exported value from AMOS in column B and the desired result in column C.
You can use this in C1:
=ROUND(B1*24,0)
Copy down as required.
Hope this helps.
Pete
You're welcome. Thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks