Thursday, March 27, 2014

yogi_Compute Time Worked In Minutes During WorkDays Given WorkBegin And WorkEnd DateAndTime And WorkStart And WorkEnd Hours

                                         Google Spreadsheet   Post  #1577
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-26-2014
post by Anuj Rastogi (!category-topic/docs/spreadsheets/IoXZDpc6oIU)
NETWORKDAYS formula showing incorrect results in Google Sheets however it is working fine in Microsoft Excel
We have been using Google Sheets to calculate the "minutes" between two dates as per Normal office working hours (8:00  - 17:00) on working days (Mon - Fri). Google sheets are showing different incorrect result than Microsoft Excel using the same formula.
These are the two dates:-
Cell(AE41)        03/16/14 19:28:00       
Cell(AF41)        03/17/14 14:15:00

Formula used in Cell (AG41)

The output Google sheets is showing 855, which is incorrect.
The output in Microsoft Excel is 375, which is correct.
Please suggest some workaround or provide a fix of this issue.
I have not checked Anuj Rastogi's formula that he said gives correct result in Excel but not in Google spreadsheet ... however

please look at the solution to a bit more generalized problem I have presented in the following