question about Time

[saud]

How to make the time result for example if it’s ( 1:01 ) or higher shows
only as ( 1:00 ) and if it’s Lower like ( 0:59 ) or less it will show
the same result in this case ( 0:59 )

Any idea & suggestions.

Thanks,

(e-mail address removed)

 

[Don Guillett]

Using Ron deBruin's google addin and asking for subject round time, I get
http://tinyurl.com/wgua

 

[Peo Sjoblom]

One way

=IF(A1>TIME(1,,),TIME(1,,),A1)

 

[Dave Peterson]

And another way:

=MIN(TIME(1,0,0),A1)

How to make the time result for example if it’s ( 1:01 ) or higher shows
only as ( 1:00 ) and if it’s Lower like ( 0:59 ) or less it will show
the same result in this case ( 0:59 )

Any idea & suggestions.

Thanks,

(e-mail address removed)

 

[saud]

Peo Sjoblom and Dave Peterson

Thank you so muc