software

Is there a way that I can easily input a start time and end time
without having to type a colon and an A or P? I have a large amount of
time data to input that I would like to streamline this process in any
way possible.I would like to enter 830 and have it show at 8:30 AM. The start times
are in the morning the end times are usually the afternoon. Any help
you could provide would be greatly appreciated.MVB
I had to do something like this recently so hopefully this can help...

go to custom number field and change one of them to this:
##quot;:quot;##quot; P.M.quot;;[Red]##quot;:quot;##quot; A.M.quot;

Then you can enter A.M. and P.M. using positive and negative numbers
and no colon.

For instance: 0808 = 8:08 p.m.
while: -0808 = 8:08 a.m (in red)

Change the formating as you need.

Josh--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: www.excelforum.com/member.php...oamp;userid=30707
View this thread: www.excelforum.com/showthread...hreadid=511135Use a help column like in the example below:

83008:3000:158:45
74507:4501:159:00
164516:4502:1519:00
00:0003:153:15

columsn A is your input
column B uses this formula:
=LEFT(TEXT(A1;quot;0000quot;);2)amp;quot;:quot;amp;RIGHT(TEXT(A1;quot;0000quot;) ;2)
column C is a time field with an increment
column D adds the increment to the time in column B.

Hope this helps

HansHi Streetboarder,

works great for display!

But when I add a time to it it treats it as 00:00?

Hans
Hans,

I only needed the format to display on the screen and for report
printing purposes. I haven't needed to do any formulas based on the
cells and I was assuming it isn't possible the way i have it set up.

Maybe some others have better ways of doing it and keeping the time
format?

Josh--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: www.excelforum.com/member.php...oamp;userid=30707
View this thread: www.excelforum.com/showthread...hreadid=511135
Hans,

I may be wrong, but I think your formula works if you replace the
semi-colons with commas, yes?--
LACA
------------------------------------------------------------------------
LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=511135