| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing time as minutes
On Sat, 24 Feb 2007 12:32:08 -0800, Teethless mama
wrote: Preformat cells as Text in Column A Create a helper Column B In B1: =IF(A1="","",TIME(0,LEFT(A1,FIND(":",A1)-1),RIGHT(A1,FIND(":",A1)-1))) Format cell as [m]:ss Why does that custom formatting work? I thought the brackets were for conditional formatting? Where is this documented? It turns out that "[s]" will show total seconds, too. So many hidden goodies in Excel. It's like a scavenger hunt. -- Running Excel 2000 SP-3 on Windows 2000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time in Minutes | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
Threaded Mode
