Quote:
Originally Posted by raogv
Dear
I requesting all who read this. start time 01 May 09 09:20:00 to 03 May
09 17:10:00 , reqired farmula for difference bewteen the time , answer
required in the formate - days:hrs:mins:sec .
Thanks regards.
--
gv
|
Just subtract, use -
Forget the date format, Excel dates are sequential numbers
Your result will be 2.32638888889051
What does this mean?
You have 2 days and 0.32638888889051 time
Assign a 37:30:55 time format to 0.32638888889051 and convert this decimal date code to 7:50:00
You have 2 days and 7:50:00 hours
Done