John Darby
asked on
Excel 3 colums in table Start, End, Duration
Greetings,
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)
=C5+TIME(E5,0,0)
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,
JohnD
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)
=C5+TIME(E5,0,0)
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,
JohnD
if you can post an example sheet, that's really helpful.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The multiplier/divisor for minutes is 1440
ASKER
Thank you so much! The hh:mm:ss helped immensely!
[m]
Kevin