Round down if time value is over 8 hours, don't round if time value is under 8 hours

[gabl136]

Hello everyone!

I have time values in excel that need to get rounded down if the value is over 8 hours (h:mm:ss), but I don't want the values rounded if it is under 8 hours...

Any ideas?

 

[gaz_chops]

Maybe

=IF(A1>TIME(8,0,0),FLOOR(A1,"0:30:00"),A1)

You don't say what you want to round it to?

 

[gabl136]

Sorry, I need it rounded to 8 hours...

 

[gabl136]

Got it

=IF(A1>TIME(8;0;0);TIME(8;0;0);A1)

gaz_chops, thanks, you are awesome!

 

[gaz_chops]

You’re welcome, just a nudge in the right direction.

 

[gaz_chops]

Another option which i think does what you want

=MIN(A1,MIN(A1,"08:00:00"))

 

[Sulprobil]

Another option which i think does what you want

=MIN(A1,MIN(A1,"08:00:00"))

One MIN seems to be ok. The right thread title might have been "Cut time at 8 hours"?
=MIN(A1,TIME(8,0,0))