Mike Lipay
Level 2 (229 points)
Mac OS X

Q: Adding duration to time

I have an application to calculate the arrival time for a time log. Ex:

 

Start Time   Duration     Est. Arrival

07:00 AM     8:25         3:25 PM (15:25 is acceptable)

 

I've noticed that Apple's time functions are very limited. I've tried a number of different ways to do this, but they all come up with formula errors (which is another issue with Apple, it doesn't always give you meaningful messages).

OS X El Capitan (10.11.3)

Posted on Sep 10, 2016 1:05 PM

by t quinn,Solvedanswer
t quinn t quinn
Level 5 (5,012 points)
Mac OS X
A:

Hi Mike,

 

For Numbers to understand a value as a duration it needs to be in a specific format. 8:25 will be understood by Numbers to be a date/time value.

Screen Shot 2016-09-10 at 8.44.40 PM.png

After the "=" in C1 I just clicked in A1 and B1.

 

quinn

Posted on Sep 11, 2016 4:17 AM

Close
Mike Lipay

Q: Adding duration to time

  • All replies
  • Helpful answers