• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Time Formatting Questiong

M

MrBlahh

Senior member
Is there a way to format time where if I enter in something like 00:24:09 it will show up as 24:09 but if I enter in 03:10:10 it will show as 3:10:10. Basically I only want to show the hours if the hours is greater than 0?

Its used for keeping track of how long something takes and it looks sloppy if its under an hour especially since most records will be under an hour.
 
There is no way i can think of, to do that directly, i.e. while entering the times on a worksheet.
Unless you use some kind of userform that will check your entry and will format the cell accordingly ....
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top