Hi,
I have some data that I’m trying to work with in numbers for iPad and I’m having 2 problems I can’t seem to figure out.
1. How do I sort by multiple columns at once? It’s basically a stack of dates with multiple time stamps each day, and I’d like to sort first by date, then by time stamp on each given date
2. Each row contains a date, time and event duration in minutes. I’m trying to convert the event duration in minutes to h:mm format (eg 90-> 1:30). I think I should be using the DURATION function, but can’t seem to get it to work. It’ll spit out something like 90hrs or 90mins.
Thanks for any help. The iOS version can sometimes be a bit tricky.
I have some data that I’m trying to work with in numbers for iPad and I’m having 2 problems I can’t seem to figure out.
1. How do I sort by multiple columns at once? It’s basically a stack of dates with multiple time stamps each day, and I’d like to sort first by date, then by time stamp on each given date
2. Each row contains a date, time and event duration in minutes. I’m trying to convert the event duration in minutes to h:mm format (eg 90-> 1:30). I think I should be using the DURATION function, but can’t seem to get it to work. It’ll spit out something like 90hrs or 90mins.
Thanks for any help. The iOS version can sometimes be a bit tricky.