• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Time Validation

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
Geekamo
Asked:
Geekamo
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Tapan PattanaikSenior EngineerCommented:
0
 
GeekamoAuthor Commented:
@ teylyn

Thank you for your input!  I appreciate it.

~ Geekamo
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now