Convert hours:mins (formatted as date) to hour value

Hi there!

I've extracted from my 20-aircraft system logs that total accumulated hours is 1325 hours and 36 minutes, formatted as date as 1325:36 [h]:mm;@.

I'd like this number to round-up to 1326 hours as a 'number-format' i.e in the formula bar not to have 24/02/1900 05:36:00.

See excel attached.

At present I've been handballing these in, but if we get 40 more aircraft this will take up a lot of time and I don't think there's a way to change my output from the system logs, is it possible?

As you have a blank column F, you can put this formula in F2:

=ROUND(E2*24,0)

or you can make it:

=ROUNDUP(E2*24,0)

if you always want to round up to the next hour. Format the cell as General, then copy down.

Hope this helps.

Pete

This reply fixed my issue within 30 minutes.

Thank you Pete_UK, reputation added!