andy206uk — Mon, 21 May 2007 18:12:15 +0000

I'm now using this which is more flexible and probably more efficient:

<?php
//**** set variables ****//

$open     = \"0823\";
$close     = \"1730\";
$dd     = \"25\";
$mm     = \"05\";
$yyyy     = \"2007\";
$slot    = \"35\";
$slot    = $slot * 60; // slot in seconds;

//***** create starting and ending timestamps **** //

$startat     = mktime(substr($open,0,2),substr($open,2,2),00,$mm,$dd,$yyyy);
$endat         = mktime(substr($close,0,2),substr($close,2,2),00,$mm,$dd,$yyyy);

//***** start looping *****//

$time = $startat;

while($time <= ($endat - $slot)) {

    echo date(\"H.i\", $time);
    echo \"<br>\";

    $time = $time + $slot;

}
?>

(in case you wondered... the dd, mm, and yyyy vars will be posted from the previous page in the final thing).

andy206uk — Mon, 21 May 2007 17:04:54 +0000

I've been thinking about this and I don't think the way that I'm doing it is the best way. I'm thinking I might be better converting the times to a time stamp and working in seconds. It's unlikely it'll happen but if one of the venues set their opening time to 8:36 for example it wouldn't work properly as is. I'm going to try doing it another way and hopefully it will be slighly more flexible than my current route...

Thanks for all the help though guys!

brady.k — Sun, 20 May 2007 03:15:37 +0000

Greg, I just saw this, and then you stole my thunder. You wrote what I was going to

andy206uk — Sat, 19 May 2007 11:16:40 +0000

Wow greg! That's super efficient code you've written there - I really have to look into 'for' loops - they seem quite handy! Thanks!

Greg K — Sat, 19 May 2007 04:39:57 +0000

Another possibility:

<?php
  $open  = 8.00;       // opening time
  $close = 16.5;       // closing time
  $slot  = 35;         // slot time in minutes
  $slot  = $slot / 60; // $slot mins as decimal
  
  for ($time = $open; $time <= ($close - $slot); $time += $slot)
  {
    $hour = floor($time);
    $min = floor(($time - $hour) * 60);
    
    echo $hour . \":\" . str_pad($min,2,'0',STR_PAD_LEFT) . \"<br />\";
  }
?>

-Greg

teammatt3 — Sat, 19 May 2007 00:20:14 +0000

So you're having a hard time taking something like 8.583 and then making it 8:35?

Can't you take the post decimal digits and multiply them by .6?

.583 * .6 = .349 (round it to .35 and take the decimal out)

.50 * .6 = .3

.25 * .6 = .15

How's that? It works for those numbers don't know about the rest though

EDIT: Oh, looks like you solved that already. I need to read the whole post before I reply

andy206uk — Fri, 18 May 2007 21:31:21 +0000

Ps... this is how my test script is looking at the moment:

<?php
    $open     = 8.00; // opening time
    $close     = 16.5; // closing time
    $time     = $open; // var for processing
    $slot    = 35; // slot time in minutes
    $slot    = (1 / 60) * $slot; // $slot mins as decimal
    
    while($time <= ($close - $slot)) {
    
        $t = sprintf(\"%.20f\",$time);
        $t = explode(\".\",$t);
        $t[1] =  \"0.$t[1]\" * 60;
        $t = implode(\".\", $t);
        $t = sprintf(\"%.2f\",$t);
    
        echo $t . \"<br />\"; // display slot time

        $time = $time + $slot; // incriment time
    
    }
?>

What do you think? Can it be made more efficient / improved?

Thanks again for the help!

andy206uk — Fri, 18 May 2007 21:26:01 +0000

Thanks Busy... not sure if I've done it wrong but that's outputting:

8.58 isn't 8 hours 58 minutes. It's 8.58 hours (if you catch my drift)

It's just formatting the numbers to two decimal places... BUT the good news is that I've sussed out the other bit. I just need to take the minutes (i.e 0.583) and multiply them by 60 and I get the proper minutes - then just stitch the time back together again! I'm probably going to use explode(".", $time) to separate the hours and minutes. Is there a more efficient way it can be done?

Busy — Fri, 18 May 2007 21:09:24 +0000

You might be better off using the time functions if you plan on adding things like time sheets ...

sprintf("%.2f",$time) would do what you want