time log formating

[anm767]

Hi guys,

I'm having some difficulty inputting time into my worksheet.
After some research I used this formatting:

0":"00":"00 AM/PM

hoping to type "80000" and get "8:00:00 AM"

The goal is to simplify input of time, no semicolon etc. Unfortunately this doesn't work once the time gets to PM, no matter what time you type it comes out as AM, such as 15:00:00 AM.

Could you suggest a different formatting or some other way or how to fix this? Would really appreciate it.

Thank you,

Andrei.

 

[mole999]

200000

 

[anm767]

That doesn't work. As I've mentioned I get 15:00:00 AM and 20:00:00 AM

I am entering Start Time, End Time, Duration.

For Duration I'm subtracting Start from End time using formula:
TEXT(B2,"00\:00\:00")-TEXT(A2,"00\:00\:00")

[TABLE="width: 378"]
<colgroup><col width="126" style="width:95pt" span="3"> </colgroup><tbody>[TR]
[TD="class: xl20, width: 126, align: right"]8:00:00 AM[/TD]
[TD="class: xl20, width: 126, align: right"]20:00:00 AM[/TD]
[TD="width: 126, align: right"]720[/TD]
[/TR]
[TR]
[TD="class: xl20, width: 126, align: right"][/TD]
[TD="class: xl20, width: 126"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Not sure why you need AM/PM with the 24-hour notation, but if you want to see 15:00:00 PM, try this custom format:

[>=120000]0\:00\:00 P\M;0\:00\:00 A\M

 

[anm767]

Not sure why you need AM/PM with the 24-hour notation, but if you want to see 15:00:00 PM, try this custom format:

[>=120000]0\:00\:00 P\M;0\:00\:00 A\M

Hi,

Thank you for the suggestion. Having 8:00:00 am and 1:00:00 PM would make more sense, but in my example it just doesn't change AM/PM whether you type in AM/PM time.