Time format / formula

[bamaisgreat]

Im trying to create a worksheet for tracking time and am having a little trouble with how I enter the time..

Simply I enter the start time in C3 and the end time in D3 and E3 (formula in E3= =D3-C3-0.5/24) shows the elapsed time.
Is it possible to customize the way I enter the date like the following... If I want 6:00 AM to show up could I simply type 06 AM and or If it was 6:24 AM I simply type 0624 AM.

 

[Special-K99]

06 implies it's AM, so AM is not needed. If you want to type AM then you dont need to type the 0 in front.

06 also implies you will enter 18 for PM.

 

[Special-K99]

Looks like you need a helper column to convert the military time into proper time.
Or VBA.

 

[bamaisgreat]

OK thanks. I didnt think about the helper column, Ill give that a try.
One more question, how can the formula be edited so when C3 & D3 are empty my E3 want show #########
This is the formula I have in E3 =D3-C3-0.5/24

 

[Special-K99]

=IF(AND(E3="",D3=""),"#########",D3-C3-0.5/24)

If E3 and D3 are both blank, then display hashes else perform the calculation.