I am making an ASP table with many rows, each row is for a 15 minute period of time in the day. My asp loops through and shows the table exactly how I want it. However, I need a way to show the time in the first column. For example, my first loop through time will be 0:00. Then for the second loop through I add 15 minutes to make it 0:15, then 0:30, 0:45 1:00, and so on.

Is there any way to do this?

Thanks!

Sure; a bit of programming:

m = 0
h = 0

For i = 1 to manyRows
m = m + 15
if m >= 60 then
   m = m - 60
   h = h + 1
end if

sTime = Cstr(h) & ":" & pad0(m)

  ... 'use sTime where you want the time...

Next


Function pad0(n)

If n >= 10 then
   pad0 = Cstr(n)
else
   pad0 = "0" & Cstr(n)
end if

end function


Joel