5 minute time intervals

[KillerF16]

How do I format the cell to show time in 5 minute intervals? ie I have B2 as 0:00, i then need each cell below that in 5 minute intervals. I have looked on here but all that I find are tied to dates and time.

Thanks in advance for any help

Rick

 

[tactps]

Welcome!!!

Try:
=TIME(HOUR(b1),MINUTE(b1)+5,SECOND(0))

 

[SIXTH SENSE]

Hi!
Another way is
type 00:00:00 in A1
type 00:05:00 in A2
then highlight both cells and drag down.
You are done!

 

[KillerF16]

Tactps

Thanks that worked