G
Guest
Hi
I have the following calculation in my column E:
=((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24
Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss
Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss
Currently my results in column E return 0.17 which equates to 10 minutes - I
really want it to show 10 minutes and not 0.17
Can anyone help?
I have the following calculation in my column E:
=((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24
Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss
Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss
Currently my results in column E return 0.17 which equates to 10 minutes - I
really want it to show 10 minutes and not 0.17
Can anyone help?