Need to calcualte secounds to the next 1/2 minute

[Paul D]

I have a Hold Time field Z1 = 4 (four Secounds)

I need to round it to .5 minutes

 

[Frank Kabel]

Hi
do you enter the seconds as Excel time or a numeric value? If you enter
them as numeric values use the following formula
=ROUNDUP((Z1/60)*2,0)/2

 

[Peo Sjoblom]

Never understood why people are using roundup when ceiling is the more
effective

=CEILING(Z1/60,0.5)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[JE McGimpsey]

One way:

To return the value in seconds:

=CEILING(Z1,30) ==> 30

To return the value in minutes:

=CEILING(Z1/60,0.5) ==> 0.5

If you want the value as a time:

=TIME(0,0,CEILING(Z1,30)) ==> 00:00:30

when formatted as hh:mm:ss

 

[Frank Kabel]

Hi Peo
I personally always forget that the function CEILING exists

 

[Peo Sjoblom]

I was just joking, although it is less calculations and easier to use IMHO

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
totally agree with you
but getting older it's getting difficult to rember new things <vbg>