Excel

I put in 10:25 begin time

10:30 end time

the calculation I set up shows a diff of 00:05 minutes it is rightIf I put in 10:59 begin time

11:00 end time

the calculation shows a diff of 00:41 minutes.

When the begin time is in one hour and the end time is in another doesn't calculate correctly

How are you doing your calculations?

What is the formula your using?A B C 1) 10:25 10:30 0:05 2) 10:25 11:00 0:35The correct formula should be =B1-A1

The cells in column C should be formatted as TIMEIf you do =A2-B2 you get -0:46

MIKE

Thanks Mike, but that did not work. Use your formula, but make the time Start Time: 13:59

End time: 14:05or

Start Time: 09:40

End time 10:10

And just what exactly is that supposed to prove? What are you trying to do?

MIKE

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History