Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Probably not possible, but thought I'd ask anyway...
I altered the h:mm time format to the custom format h "hrs", m "mins". So, if I type 3:3, the cell reads "3 hrs, 3 mins" just fine. But if I type 1:1, I get "1 hrs, 1 mins" . Is there some custom format that will drop off the "s" when the hour or minute is "1"? Furthermore, can such a format drop off the hour or minute altogether if a "0"? Here's a recap of what I'm looking for: I Type Cell Reads ------- ------------- 2:2 2 hrs, 2 mins 2:1 2 hrs, 1 min 1:2 1 hr, 2 mins 1:1 1 hr, 1 min 0:2 2 mins 0:1 1 min 2:0 2 hrs 1:0 1 hr Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format a cell for hours ' minutes " | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" | Excel Worksheet Functions | |||
Custom Time Format doesn't work for me | Excel Discussion (Misc queries) |