Reading Time

B

Brento

HI,

I am trying to write a formula that will be read how many seconds afte
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
Brent
 
D

daddylonglegs

If your time is in A1 then use this formula

=MOD(A1*86400,900)

format as general or number
 
A

Alan

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.
 
Top