ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtracting time in date format (https://www.excelbanter.com/excel-worksheet-functions/6150-subtracting-time-date-format.html)

Collcat

Subtracting time in date format
 

I don't get it from the formulas.

Should one use some kind of IF statement?


// Coolcat


--
Collcat
------------------------------------------------------------------------
Collcat's Profile: http://www.excelforum.com/member.php...o&userid=15598
View this thread: http://www.excelforum.com/showthread...hreadid=277036


anilsolipuram


If am not sure if I understood your question.

So you have due dates available , you want to calculate the start date
for the assignment. Assignment time is 8 weeks, is that correct.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277036



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com