Numbers 08 - Time arithmetic?

Jump to First Reply
tilttilt
Posted:
in Genius Bar edited January 2014
Hi,



There is probably a very simple answer to this and I am probably just being dumb, but here goes anyway...



I am trying out the trial version of Numbers. I have an Excel sheet where I have Start Time and End Time and in the third column I calculate the elapsed duration. All columns are formatted as Time, so entering b-a in c gives me the correct answer.



I opened this sheet in Numbers. The elapsed duration column gives me weird numbers. I tried to find a way to format that column as Date and Time, found it in the Inspector, but nothing happened.



Any ideas on what I am missing doing?



Thanks and cheers
Sign In or Register to comment.