Geekamo
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ teylyn
Thank you for your input! I appreciate it.
~ Geekamo
Thank you for your input! I appreciate it.
~ Geekamo
Please check these links.
How to use dates and times in Excel:
http://support.microsoft.com/kb/214094
Changing Time Formats in Microsoft Excel:
http://www.ehow.com/video_4445753_changing-time-formats-microsoft-excel.html
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
http://en.allexperts.com/q/Excel-1059/Excell-Time-Format.htm