I know the start time of an activity and also the total number of hours, I want to computer the completion time. I may not be formatting the values correctly.
Start time: 9:00 AM
Length: 11.5
Completion time: ????
I know the start time of an activity and also the total number of hours, I want to computer the completion time. I may not be formatting the values correctly.
Start time: 9:00 AM
Length: 11.5
Completion time: ????
Hello & Welcome to the board,
How about...
=A1+(A2/24)
A1 = Start Time
A2 = Length
Format as time
HTH
Regards, Jeff
A1 = Start time: 9:00 AM
A2 = Length: 11:50
A3 = End time =A1+A2 =20:50
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks