Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-11-2016, 11:49 PM
dlquinte dlquinte is offline Change houre notation when wrong notation is entered Windows 10 Change houre notation when wrong notation is entered Office 2013
Novice
Change houre notation when wrong notation is entered
 
Join Date: Apr 2016
Posts: 3
dlquinte is on a distinguished road
Default Change houre notation when wrong notation is entered

Hello,

I am working on a file that (a lot of) other people have to fill in, it's all about starting hours and ending hours of workshifts etc...
So now I programmed everything in excel 2013 so I can do calculations with the entered houres. One rule is that everything has to be filled out in the form of "xx:xx", e.g. "17:00". But people are using everything as notation: "17h", "17h00", even "1700"... My question now is: is there a way to change all these notations to "17:00" automatically?



I have been telling the people that they need to put it that specific way, but they're hard learners apparently...
Just wondering if my question is possible or not?

Thanks in advance!
dlquinte
Reply With Quote
  #2  
Old 04-12-2016, 03:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Change houre notation when wrong notation is entered Windows 7 64bit Change houre notation when wrong notation is entered Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
converting all possible entries could be difficult and would need VBA ( if doable)

OTH you can try using Data Validation to force the user to enter the proper format
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Musical Symbols/notation Iliaryn Word 2 03-07-2016 12:12 AM
Change houre notation when wrong notation is entered congruence notation, mod, modulus komjathy Word 3 09-22-2012 11:35 AM
Change houre notation when wrong notation is entered typing out mathematical notation gib65 Word 2 08-31-2011 02:21 PM
Change houre notation when wrong notation is entered why the "page break" notation appears improperly? Jamal NUMAN Word 1 07-19-2011 03:39 AM
Change houre notation when wrong notation is entered when Word gives notation for style separator and when it doesn't? Jamal NUMAN Word 1 06-26-2011 05:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:15 AM.


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