Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
How to sum a duration that carries into the next day.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="PilotPat" data-source="post: 1688281" data-attributes="member: 361826"><p>Hello all. I have a Numbers spreadsheet that calculates duty time (or hours worked) expressed in 24hour format. The issue I am finding is that when the 'Off Time' carries into the next day the formula returns a negative value. For example:</p><p></p><p>A3 has the following formula: =A2-A1 </p><p></p><p>A1 = time on</p><p>A2 = time off</p><p>A3 = total time worked</p><p></p><p>so if </p><p></p><p>A1 = 19:00</p><p>A2 = 02:00</p><p>A3 = -17h (when it should total 7h)</p><p></p><p>Any ideas? Thank you in advance!!!</p><p></p><p>-Patrick</p></blockquote><p></p>
[QUOTE="PilotPat, post: 1688281, member: 361826"] Hello all. I have a Numbers spreadsheet that calculates duty time (or hours worked) expressed in 24hour format. The issue I am finding is that when the 'Off Time' carries into the next day the formula returns a negative value. For example: A3 has the following formula: =A2-A1 A1 = time on A2 = time off A3 = total time worked so if A1 = 19:00 A2 = 02:00 A3 = -17h (when it should total 7h) Any ideas? Thank you in advance!!! -Patrick [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
How to sum a duration that carries into the next day.
Top