Help with time please.

F

Floyd Forbes

I have this formula that caluclates
time"=IF(K27-E25+F25-L27<=0,0,K27-E25+F25-L27)".
in cell G25. It works fine if E25 is 11:00 PM and F25 is 11:30 PM. If I try
to calculate E25 is 11:55 PM and F25 is 12:05 AM it gives me 0:00. What is
wrong?

Floyd
 
P

Pete_UK

This also depends on your values of K27 and L27 (I suspect these are
dates), but think of 12:05AM as being 0:05 - it is less than 23:55
(11:55PM), and as you are subtracting one from the other the result is
less than 0, so your formula returns 0.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help 7
Getting Incorrect Calculation From Formula 1
Suming Up Time over the course of days 1
Calculate Face Time 4
Help with simple formula 2
calculate total hours/minutes from two time cells 7
Finding if a certain time falls between two other times: 1
Min, Max 3

Top