#1
|
||||
|
||||
Custom format 4 digit number to 0:00
Hi. Is there a way to format a number, say when the number 230 is entered, 2:30 should appear and 1130 to 11:30? I tried typing #0:00 in the custom format option but got an error message.
Thank you. |
#2
|
|||
|
|||
Does this work for you?
##0":"00 |
#3
|
||||
|
||||
Yes it does perfectly. And to think that I was resigned to resort to a vba that I found in my search as a solution to this simple yet complex problem.
Thank you Purfleet. |
#4
|
|||
|
|||
But for example 230 + 1135 gives 13:65. Is that what you want?
|
#5
|
||||
|
||||
Zor, there are no calculations. Just plain, tedious encoding of daily time ins and time outs.
|
#6
|
|||
|
|||
Pardon me.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
isolate the last digit of each number. | joni | Excel Programming | 2 | 06-25-2020 04:12 AM |
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 | laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
Creating a custom number format | bremen22 | Excel | 2 | 01-16-2014 07:23 AM |
Custom Number Format for Chart | deadrxn24 | Word | 4 | 03-18-2012 05:38 PM |
custom number format: change thousands separator | Ward | Excel | 1 | 06-07-2011 08:18 PM |