Inscrit le: 21 Sep 2017
Moyenne de points: 0
|Posté le: Lun 30 Oct - 17:03 (2017) Sujet du message: Numbers 08 - Time arithmetic?
|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
I didn't find the right solution from the Internet.