I'm trying to get the difference in hours between two dates which are displayed in a different format (one is in mm/dd/yyyy and the other is in dd/mm/yyyy). Changing the format cell doesn't help.
I'm trying different solutions without being able to succeed. Basically I would like to format the first one to display dd/mm/yyyy to make it work.
here is a sample:
Date Opened Date Closed Formula applied Result
8/1/2015 2:04 PM 14-01-2016 3:35 PM =SUM(((NETWORKDAYS(A2,B2)-1)*24),HOUR(B2-A2)) 6361 (Excel thinks the first is Jan and not August)
1/13/2016 12:04 PM 14-01-2016 3:35 PM =SUM(((NETWORKDAYS(A3,B3)-1)*24),HOUR(B3-A3)) #VALUE! (doesn't recognize 13 as a month I believe)
Any ideas? Thanks!!
I'm trying different solutions without being able to succeed. Basically I would like to format the first one to display dd/mm/yyyy to make it work.
here is a sample:
Date Opened Date Closed Formula applied Result
8/1/2015 2:04 PM 14-01-2016 3:35 PM =SUM(((NETWORKDAYS(A2,B2)-1)*24),HOUR(B2-A2)) 6361 (Excel thinks the first is Jan and not August)
1/13/2016 12:04 PM 14-01-2016 3:35 PM =SUM(((NETWORKDAYS(A3,B3)-1)*24),HOUR(B3-A3)) #VALUE! (doesn't recognize 13 as a month I believe)
Any ideas? Thanks!!