<div>
Hi Geekamo,<br />
<br />
<b>Please check these links.<br />
<br />
How to use dates and times in Excel:<br />
<br />
<a href="http://support.microsoft.com/kb/214094" rel="ugc">http://support.microsoft.com/kb/214094</a><br />
<br />
Changing Time Formats in Microsoft Excel:<br />
<br />
<a href="http://www.ehow.com/video_4445753_changing-time-formats-microsoft-excel.html" rel="ugc">http://www.ehow.com/video_4445753_changing-time-formats-microsoft-excel.html</a><br />
<br />
<br />
<a href="http://www.ozgrid.com/Excel/ExcelDateandTimes.htm" rel="ugc">http://www.ozgrid.com/Excel/ExcelDateandTimes.htm</a><br />
<br />
<a href="http://en.allexperts.com/q/Excel-1059/Excell-Time-Format.htm" rel="ugc">http://en.allexperts.com/q/Excel-1059/Excell-Time-Format.htm</a></b>
</div>


Hi Geekamo,

Please check these links.

How to use dates and times in Excel:

http://support.microsoft.com/kb/214094 [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.ehow.com/video_4445753_changing-time-formats-microsoft-excel.html]


http://www.ozgrid.com/Excel/ExcelDateandTimes.htm [http://www.ozgrid.com/Excel/ExcelDateandTimes.htm]

http://en.allexperts.com/q/Excel-1059/Excell-Time-Format.htm [http://en.allexperts.com/q/Excel-1059/Excell-Time-Format.htm]

<div>
@ teylyn<br />
<br />
Thank you for your input! &nbsp;I appreciate it.<br />
<br />
~ Geekamo
</div>


@ teylyn

Thank you for your input!  I appreciate it.

~ Geekamo

<div>
<div class="content wysiwyg-content">
Hello Experts!<br />
<br />
I am working on a spreadsheet, in which range E:I contains time values.<br />
<br />
IE - 1:02:32 (1 hour, 2 minutes, 32 seconds) or 0:01:07 (1 minute, 7 seconds)<br />
<br />
All time values can range from just seconds, into hours. &nbsp;The format of the time is &quot;#:##:##&quot;.<br />
<br />
What validation rule do I need to apply, in order to force users to type in this format<br />
<br />
#:##:##<br />
<br />
Thank you in advance for your help!<br />
<br />
~ Geekamo
</div>
</div>


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

Time Validation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.