ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   delivery time versus pickup time (https://www.excelbanter.com/excel-worksheet-functions/451028-delivery-time-versus-pickup-time.html)

[email protected]

delivery time versus pickup time
 
I am looking to create a function that will see if the delivery time is greater than 2 hours after the pickup time to show the delivery was late.

Claus Busch

delivery time versus pickup time
 
Hi,

Am Wed, 12 Aug 2015 08:33:08 -0700 (PDT) schrieb
:

I am looking to create a function that will see if the delivery time is greater than 2 hours after the pickup time to show the delivery was late.


if(delivery time - pickup time 1/12, "Late","")

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


All times are GMT +1. The time now is 07:17 AM.

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