Time values that add up to greater than 24 hours
Hi Apple SUpport Community,
I am trying to get a cell in Numbers to return a TIME value when the sum of two time values are greater than 24.
For example, if a worker has a shift that starts at 8pm and works for 6 hours and 15 minutes, the shift ends at ((20:00+06:15=26:15)-24:00)=02:15am the next day.
If I formulate a cell in numbers to add to time values, it comes return the nasty red triangle saying "The Formula's arguments can only contain one date value"
Thanks in advance for any help!
ST