How do I calculate hours in Numbers?
How do I calculate hours in Numbers? Example: I inserts 7:00 in a cell and 11:30 in another cell. What function do I write to get 4:30?
MacBook Pro (15-inch Early 2011), OS X Mavericks (10.9.2), Numbers 3.1
Hi Interlaga,
Enter start time in A2. Enter finish time in B2. They will become Cell > Data Format > Automatic with Date and Time (Date None).
Formula in C2
=B2−A2
That becomes Cell > Data Format >Automatic
Refinement is to use 'Date and Time' Format for start and finish, and 'Duration' format for the difference.
Remember that in Numbers, every Date has a Time attached, and every Time has a Date attached (even if they are not displayed in the cell). So if you enter the times on different days (the 'crossing midnight' problem) the finish time will be 24 hours later 🙂.
It took me a while to understand this, but a Time or a Date is an instant since 1 January 1904.
Call back for more help.
Regards,
Ian.