MacMost Now 747: Using Time and Duration Values In Numbers

You can represent specific times and time durations in cells in iWork Numbers. You can format the cells to display the times and dates in a variety of ways. You can perform calculations on both and get intelligent results, such as the difference between two times.

Comments: 4 Responses to “MacMost Now 747: Using Time and Duration Values In Numbers”

    Nilesh Parmar
    7 years ago

    Wow I didn’t realise it can do that, great tut

    Chuck
    7 years ago

    Interesting. But I’d be interested in seeing if you can add a time stamp to entries. Maybe using that IF formula with checkboxes. When you arrive at work and check the ‘IN’ box it shows the time in the field beside it. When you check the “OUT” box it also displays the time and then calculates the time worked, or whatever. Is that possible? Or is there an easier way to do it?

    And, BTW Gary- you do a great job with this. Your library of videos is extremely useful. I hope the sponsors are catching on to you. Chuck

      7 years ago

      I don’t think so. Formulas always update to show “live” data, so having it change the data after an action, but then stop changing it after that… not something I think I’ve seen. Maybe a database app is more appropriate for this sort of thing.

    John Pollard
    7 years ago

    Very impressive tutorials. Well done.

Comments Closed.