|
|
|
|
#1
09-22-2019, 05:34 PM
|
|||
|
|||
You can change the times directly in the C column using VBA,
but if you want a formula solution in column D, try this in D1 and drag down = TIMEVALUE("00:" & HOUR(C1) & ":" & MINUTE(C1)) 
|
|
| Tags |
| format cells |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2013 Messages can sit in the Outbox anywhere from 5 seconds up to 60 seconds | BNS1968 | Outlook | 0 | 09-16-2016 08:07 PM |
 Format a range of cells
|
Dave T | Excel Programming | 1 | 06-01-2016 08:58 PM |
|
Convert large seconds values to a time format fails with #Value
|
Sekerob | Excel | 3 | 07-18-2015 01:56 PM |
|
Procedure for displaying symbols for degrees, minutes, seconds
|
kinglaird | Excel | 1 | 01-17-2015 02:04 AM |
|
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode