Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting time
Anyone know if there is a function for subtracting the difference
between two times, though, using negative data such as 2:51 am - 9:08 pm. Yes, I could figure it out in my head but when one has to do hundreds of them, it's time consuming. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting time
Meanie wrote:
Anyone know if there is a function for subtracting the difference between two times, though, using negative data such as 2:51 am - 9:08 pm. Yes, I could figure it out in my head but when one has to do hundreds of them, it's time consuming. Don't multipost. If you can't post to more than one group at a time in Google Groups, then pick ***ONE*** that is most appropriate and post there. Answered in microsoft.public.excel.programming. -- I feel responsible. He's my Chinese obligation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting time
On Monday, 9 April 2018 03:23:43 UTC+1, Auric__ wrote:
Meanie wrote: Anyone know if there is a function for subtracting the difference between two times, though, using negative data such as 2:51 am - 9:08 pm. Yes, I could figure it out in my head but when one has to do hundreds of them, it's time consuming. Don't multipost. If you can't post to more than one group at a time in Google Groups, then pick ***ONE*** that is most appropriate and post there. Answered in microsoft.public.excel.programming. -- I feel responsible. He's my Chinese obligation. Try =MOD(A1-B1,1) Regards Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting a duration from a time to calculate a time. | Excel Discussion (Misc queries) | |||
Subtracting Time. | Excel Worksheet Functions | |||
Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
subtracting two date/time columns to get total time | Excel Programming |