Hello.
I am working to calculate the elapsed time, in hh:mm:ss between two date/time fields, including days. Such as 4/24/2002 3:58:15 PM and 4/25/2002 8:37:51 PM. I can use TEXT(F14-E14,"h:mm:ss"), but it does not handle the 28 hours.
Any suggestions?
I am working to calculate the elapsed time, in hh:mm:ss between two date/time fields, including days. Such as 4/24/2002 3:58:15 PM and 4/25/2002 8:37:51 PM. I can use TEXT(F14-E14,"h:mm:ss"), but it does not handle the 28 hours.
Any suggestions?