| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Minutes and Seconds
I want to enter a date as if I were denoting the minutes and seconds left in
a sporting event, i.e., 4:10 to represent 4 minutes and 10 seconds. I do NOT want an hour to be applied to the time (ex: 3:04:10). I do not see a way to do this with Excel time formatting options. Each one uses an hour/minute/second format. Help anyone? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Hours and Minutes | Excel Discussion (Misc queries) | |||
| How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| Minutes to seconds - how to convert? | Excel Worksheet Functions | |||
Threaded Mode
