cros$$ Formaula to calculate Turnaround time excluding
non working hours
non office hour ,you mean excluding sat and sun?
On Wed, Jan 23, 2013 at 1:55 AM, Amit Desai (MERU)
mailto:amit.de...@merucabs.com>> wrote:
How shall I remove the non office hours...
Best Regards,
Amit Desai
+91 98672 3
calculate Turnaround time excluding
non working hours
if date and time is in correct formate
then
=C3-B3
apply format [h]:mm
Rajan
On Tue, Jan 22, 2013 at 10:49 AM, >>Excel Beginner<<
mailto:excelbegin...@gmail.com>> wrote:
Hi Amit,
You can use the following formu
Dear All,
I need a small formula to calculate Turnaround time excluding non working hours
(in this example - working hours is 09:30 AM to 18:30 PM).
Cab No.
In Time
Out Time
TAT
DL1RY1234
22-01-2013 10:00
23-01-2013 15:30
16:30:00
Need this with Formula
Please help.
Best Regards,
Ami
