SNA400
New Member
- Joined
- Nov 5, 2010
- Messages
- 49
I need to count the number of hours between 2 dates. example I need the difference between 21/04/2014 00:10 and 23/04/2014 23:50 (answer is 47h 40 mins)
The cells have a start/finish date/time in the format dd/mm/yyyy hh:mm
When I minus the start date/time from the finish date/time I want the result to be number of total hours.
I have tried SUM(A1-B1) but this only calculates the difference between the two hour totals
I have also tried the formula below
=NETWORKDAYS(D4,E4)+NETWORKDAYS(E4,E4)*(MOD(D4,1)-1)-NETWORKDAYS(D4,D4)*MOD(D4,1)
but this only shows me the time entry in D4
I an sure there is a simple answer to this question - but I can't work it out!
Simon
The cells have a start/finish date/time in the format dd/mm/yyyy hh:mm
When I minus the start date/time from the finish date/time I want the result to be number of total hours.
I have tried SUM(A1-B1) but this only calculates the difference between the two hour totals
I have also tried the formula below
=NETWORKDAYS(D4,E4)+NETWORKDAYS(E4,E4)*(MOD(D4,1)-1)-NETWORKDAYS(D4,D4)*MOD(D4,1)
but this only shows me the time entry in D4
I an sure there is a simple answer to this question - but I can't work it out!
Simon