The problem to be solved is: you have in column A a start date and column B data on a start time and end time of work, possibly the next day, knowing that the work period may not exceed 18 hours.
The objective is to calculate the elapsed time between the times shown.
could certainly get the result without macro, but the price is additional columns for intermediate calculations or formulas particularly indigestible. formula C2, reproduced down, is: = hours (B2) .
The macro function above is the work of David Smart, a renowned expert in Excel.
0 comments:
Post a Comment