Reading Time

HI,

I am trying to write a formula that will be read how many seconds after a 15 mintue interval has lapsed.

Example. 14:02 = 120 seconds 14:49 = 240 seconds.

It will always be 00:00, 00:15, 00:30, 00:45 past the hours.

thanks in advance
Brento

If your time is in A1 then use this formula

=MOD(A1*86400,900)

format as general or number

With the start time in A1 and the end time in A2,
=(A2-A1)*86400
where 86400 = 24*60*60, the number of seconds in 24 hours
Regards,
Alan.
"Brento" <Brento.2cecfj_1155334809.8962@excelforum-nospam.com> wrote in
message news:Brento.2cecfj_1155334809.8962@excelforum-nospam.com...
>
> HI,
>
> I am trying to write a formula that will be read how many seconds after
> a 15 mintue interval has lapsed.
>
> Example. 14:02 = 120 seconds 14:49 = 240 seconds.
>
> It will always be 00:00, 00:15, 00:30, 00:45 past the hours.
>
> thanks in advance
> Brento
>
>
> --
> Brento
> ------------------------------------------------------------------------
> Brento's Profile:
> http://www.excelforum.com/member.php...o&userid=25213
> View this thread: http://www.excelforum.com/showthread...hreadid=570941
>