This did not work. A1 = 4/2/2007 11:50:00 AM
B1 = 4/2/2007 1:15:00 PM
When I format the cells for hh:mm, C1=A1- B1 gives me #Value. I tried
formatting the cells to mm/dd/yyyy h:mm:ss AM/PM, but still getting #Value.

Suggestions?


"Toppers" wrote:

A1 start time
B1 end time
C1 =B1-A1

format as hh:mm

"Darren" wrote:

How can I get the difference in time from 10:35:00 to 11:45:00.
I have a program to exports the following to excel:
2/9/2007 12:45:00 PM [start time]
2/9/2007 4:15:00 PM [end time]

How can I create a formula to give me the diffence in these times?