Working Day Calculation

  • Thread starter Thread starter Vinod Chandramouli
  • Start date Start date
V

Vinod Chandramouli

Alright guys I have a question,

I have two columns.

Column A Column B
12/3/2008 8:08 12/7/2008 12:07

Let's says I need the result in Column C, so Column C should look like
this

Column C
4 Days 17 Hours 3 Minutes

Now the criteria in which it should calculate are the following.

1) It should ignore Saturday and Sunday. Say for an example if the
value on Column A falls on a Friday , it should ignore saturday and
sunday and start calculating from Monday.

Any help is greatly appreciated !

regards
VC
 
Hello,

Its more like 2 days 15 hours and 52 minutes. We should only count
days and time from Wednesday 3-Dec-2008 8:08 to Friday 5-Dec-2008
24:00, I presume.

I suggest to take my UDF count_hours:
http://www.sulprobil.com/html/count_hours.html

Enter start date/time into A1, End date/time into A2,
0:00:00 24:00:00
0:00:00 24:00:00
0:00:00 24:00:00
0:00:00 24:00:00
0:00:00 24:00:00
0:00:00 0:00:00
0:00:00 0:00:00
into D1:E7
and finally into B1, for example:
=INT(count_hours(A1,A2,D1:E7)) & " Day(s) " & TEXT(MOD(count_hours
(A1,A2,D1:E7),1),"[h]:MM") & " Hour(s):Minute(s"

Regards,
Bernd
 
Back
Top