Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Custom format 4 digit number to 0:00 Custom format 4 digit number to 0:00
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-05-2021, 04:30 PM
Marcia's Avatar
Marcia Marcia is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2019
Expert
Custom format 4 digit number to 0:00 		 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote
  #2  
Old 06-05-2021, 09:31 PM
Purfleet Purfleet is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Does this work for you?

##0":"00
Reply With Quote
  #3  
Old 06-05-2021, 09:42 PM
Marcia's Avatar
Marcia Marcia is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2019
Expert
Custom format 4 digit number to 0:00 		 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by Purfleet View Post
Does this work for you?

##0":"00
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.
Reply With Quote
  #4  
Old 06-05-2021, 10:03 PM
xor xor is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
But for example 230 + 1135 gives 13:65. Is that what you want?
Reply With Quote
  #5  
Old 06-05-2021, 10:15 PM
Marcia's Avatar
Marcia Marcia is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2019
Expert
Custom format 4 digit number to 0:00 		 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Zor, there are no calculations. Just plain, tedious encoding of daily time ins and time outs.
Reply With Quote
  #6  
Old 06-05-2021, 11:06 PM
xor xor is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Pardon me.
Reply With Quote
Reply

« Previous Thread | Next Thread »


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
Custom format 4 digit number to 0:00 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
Custom format 4 digit number to 0:00 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 format 4 digit number to 0:00 custom number format: change thousands separator Ward Excel 1 06-07-2011 08:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:36 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft