| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| How can I calculate the difference between times without using th. | Excel Worksheet Functions | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
