how do I figure the difference between two times when one is in p.
 

I am compiling time study information. I have my formula set up as follows:
=(B16-A16)*1440 with B16 being the end time and A16 being the start time.
I need a basic figure of minutes when I'm done. If I have a start time of
11:55 pm and an end time of 12:15 am it gives me a difference of -1420. How
do I fix this so that I get the correct answer of 20 minutes?

Try...

=(B16-A16+(B16<A16))*1440

Hope this helps!

In article ,
tammyj wrote:

I am compiling time study information. I have my formula set up as follows:
=(B16-A16)*1440 with B16 being the end time and A16 being the start time.
I need a basic figure of minutes when I'm done. If I have a start time of
11:55 pm and an end time of 12:15 am it gives me a difference of -1420. How
do I fix this so that I get the correct answer of 20 minutes?

Yes! It works! Thank you!

"Domenic" wrote:

Try...

=(B16-A16+(B16<A16))*1440

Hope this helps!

In article ,
tammyj wrote:

I am compiling time study information. I have my formula set up as follows:
=(B16-A16)*1440 with B16 being the end time and A16 being the start time.
I need a basic figure of minutes when I'm done. If I have a start time of
11:55 pm and an end time of 12:15 am it gives me a difference of -1420. How
do I fix this so that I get the correct answer of 20 minutes?