time sub

[kxlvba]

I have time in the following format.
9/27/2006 5:49:17 PM
In another column I have time as 3:00:00 PM.
Now, I need to subtract times, but the format 9/27/2006 5:49:17 PM is causing issue and I'm not able to sub time and get the information. Can I use the Text(...."hh:mm....) etc

 

[BJungheim]

What is the expected result? 2:19:17? If so, is the 3:00:00 PM just 3:00:00 PM or is it 9/27/2006 3:00:00 PM formatted to hide the date?

 

[kxlvba]

Got it I used =Text(Reference Cell, "h:mm")

Had that in mind, but wasn't getting it.

Thanks.

But if you can now help me with something else.

How do I conditional format A1:Z1 in red if the condition in Z1 > 2:00

 

[Richard Schollar]

How do I conditional format A1:Z1 in red if the condition in Z1 > 2:00

1. Select A1:Z1 and go Format>Conditional Formatting
2. Change to Formula Is
3. Type in =$Z1>0.08
4. Select format required and click OK.

2 hours is equivalent to 2/24ths of a day = 0.08.

Richard