View Single Post
  #2   Report Post  
Domenic
 
Posts: n/a
Default

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?