I am having a strange boggle with linking time between Start, End, Duration for each line in my table; first, here is the sample of what I have thus far:
C5=Start Time (lookup to D4)
D5=End Time (calculation by adding value in C5 to duration in E5)
However, when I want to show duration including minutes, instead of whole hours, I can't seem to get the display correct...it won't who minutes
eg. if the Duration=1 hour 10 minutes, how do I express that numerically in E5 so it is understood by the formula above?
Thank you, in-advance,