Adding Time in Numbers

Nov 16, 2014
Reaction score
Your Mac's Specs
2017 MacBook Pro 13" | iPad Air 2 | Apple Watch 3 | iPhone XS
I have some questions and need some help with adding time in Numbers.

I am using a late 2012 Mac Mini updated to the newest of OS X Yosemite (10.10.2).
2.5 GHz i5, 4GB DDR3.

iWork is updated the most current available on the app store.

Ok, so I have some questions. I get commission for my job, but there are times that I need to log hours and have that added up. I have figured out a few things with numbers as I'm still trying to learn that vs MS Office. But I'm still not up to speed on all of it.

So this is what I'm trying to do:

1 Date Account # Customer Name Time in Time out Total hours
2 03/03/15 111555 Test Account 1 11:40 AM 12:30 PM 0:50
3 03/03/15 111556 Test Account 2 2:10 PM 3:10 PM 1:00
4 03/04/15 111557 Test Account 3 10:20 AM 10:40 AM 0:20

With the above info I have figured out to subtract column E from column D to get my time.
Column F is formatted into Duration and columns D & E into Date/Time.

I've also found out that if I copy the formula from rows F2-F4 to other columns I get an error in the cell I'm using for the total, unless I fill in all associated cell with times. Then everything works great.

So why do I HAVE to have a value in the other cells? Am I missing a setting? Or a better formula?

Any help would be great..


Shop Amazon

Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.