Thread
:
how do i convert a number into minutes for a time of completion c.
View Single Post
#
3
Nick Hodge
Posts: n/a
Reading that back was just an answer for the exact question, for a lot more
info on how excel handles dates and times take a look here
http://www.cpearson.com/excel/datetime.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Nick Hodge" wrote in message
...
Set up the following
A1 = Start time (say 10:00)
A2 = Task Duration (I am presuming you want to enter 20 instead of 00:20)
A3 = formula =A1+((A2/24)/60)
Answer = 10:20 when formatted as hh:mm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"dhelmers" wrote in message
...
I do not know where to get a formula to convert a number into minutes and
have it take a given time and add to it to give me a completion time for
a
specific task
Reply With Quote