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

T

tammyj

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?
 

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

Calculating the difference, in hours, between two date/time in two different time zon 2
count how many staff are scheduled between... 4
Subtracting Time. 4
Difference Between Two Times 5
Formula for adding time 2
difference between two time 3
How to calculate the difference between two different times. 1
How to calculate the difference between two different times. 1

Top