Solved

Time Validation

Posted on 2012-12-29
3
228 Views
Last Modified: 2012-12-30
Hello Experts!

I am working on a spreadsheet, in which range E:I contains time values.

IE - 1:02:32 (1 hour, 2 minutes, 32 seconds) or 0:01:07 (1 minute, 7 seconds)

All time values can range from just seconds, into hours.  The format of the time is "#:##:##".

What validation rule do I need to apply, in order to force users to type in this format

#:##:##

Thank you in advance for your help!

~ Geekamo
0
Comment
Question by:Geekamo
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 38730485
Hello,

format the cell with one of the built-in time formats or the custom format

h:mm:ss

Now the decimal part of any number that is entered into that cell will be shown as a time value.

Excel stores time as decimals. There is no data validation out of the box that can check if a user has entered the time value 1:20:33 or the corresponding decimal 0.0559375

cheers, teylyn
0
 
LVL 21

Expert Comment

by:Tapan Pattanaik
ID: 38730512
0
 
LVL 1

Author Closing Comment

by:Geekamo
ID: 38731363
@ teylyn

Thank you for your input!  I appreciate it.

~ Geekamo
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now