ExcelBanter - Adding time, but only to 80 hrs.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding time, but only to 80 hrs. (https://www.excelbanter.com/excel-discussion-misc-queries/194562-adding-time-but-only-80-hrs.html)

Elena

Adding time, but only to 80 hrs.

I am able to add up hours, but I only want to add hours to 80. Is this
possible?

John C[_2_]

Adding time, but only to 80 hrs.

Assuming your hour hours are in decimal form.

=MIN(SUM(YourHours),80)
--
John C

"Elena" wrote:

I am able to add up hours, but I only want to add hours to 80. Is this
possible?

All times are GMT +1. The time now is 02:28 AM.