Forum Discussion
Time conversion formula
For example:
Select A2 and press Ctrl+Shift+; to enter the current time (we cannot use a formula such as =NOW() for that would be updated each time Excel recalculates).
Enter total litres in B2.
Enter flow rate in C2.
Enter the following formula in D2:
=IFERROR(A2+B2/C2/24, "")
Format D2 as time.
The formula can be filled down.
For example:
Select A2 and press Ctrl+Shift+; to enter the current time (we cannot use a formula such as =NOW() for that would be updated each time Excel recalculates).
Enter total litres in B2.
Enter flow rate in C2.
Enter the following formula in D2:
=IFERROR(A2+B2/C2/24, "")
Format D2 as time.
The formula can be filled down.
Thank you so much! One more question. I was hoping this formula would work for another equation, but it's not jiving. Say I want 'Total Litres' to be subtracted with 'Current Litres Delivered' then be divided by 'Flow Rate'. How would that change the equation so I can still get a completed time in relation to the current time. For some reason, it is subtracting from the current time instead of adding when I entered =IFERROR(A2+B2-C2/D2/24, "")
