Forum Discussion
Having an Issue with Excel hour/time formatting
Another way:
1) Insert new empty column (L) next to your column with time (K) and format it as [h]:mm
2) Into new column add formula
=K2/24
and drag it down
Here you have correct elapsed time now
And in attached file
I never said I was a pro LOL, but here is a very messy way of doing what I think I need to.
1) created 4 new colums
2) Text to columns, using "." as a deliminter on the cell with the hours (ex: 92.73)
3) Took 60 and multipled 73% (from example above answer is 44.6)
4) Took the 44.6 and then did =round(44.6,0) This allowed me to remove the "."
5) last column added it all together =K2&"."&N2 answer is 92.44
Like I said, ugly but has to be a better way.
Another way:
1) Insert new empty column (L) next to your column with time (K) and format it as [h]:mm
2) Into new column add formula
=K2/24
and drag it down
Here you have correct elapsed time now
And in attached file
Thank you, this was the fastest and easiest way. While the mround worked, this is the simpliest.
Mike,
it depends on what you want.
Sergei's formula is to the second, my formula is to the minute.
92.73 -> 92:43:48 -> 92:44:00
Ahhh that makes sense, thank you clarifying.
