Duration formula
I'm using google spreedsheet, I have here 3 column's. Column A row 1 header title is "time start". Column B row 1 header title "time end" and Column C row 1 "duration. Column C time format is "dd:hh:mm:ss"
can provide formula to use in Column C to compute the duration of Column A and B. but only if there is value in column B if there is none Column C will compute Column A and todays current time.
I'm using google spreedsheet, I have here 3 column's. Column A row 1 header title is "time start". Column B row 1 header title "time end" and Column C row 1 "duration. Column C time format is "dd:hh:mm:ss"
can provide formula to use in Column C to compute the duration of Column A and B. but only if there is value in column B if there is none Column C will compute Column A and todays current time.