Hi may I know why we could compute a duration in # of Day, Hours and Minutes.
For example, column 1 is Date 2005/09/22 and Column 2 is Time 10:20:15.
Assuming now is 2005/09/23 and Time 06:14:30. How do I make use of excel
function to get value 0 Days 19 Hrs 54 mins in column 3 ?
Thanks.