[Resolved] HELP!! With time format.

discostudio

Hi Guys,

OK, a start time is stored in my database as follows:

12:00:00 meaning 12pm Midday.

To make it say 12:00pm I simply use the following code:

echo date("g:i a", strtotime($r['start_time']));

Now the customer can select the finish time by selecting how many hours,

So a start time is 20:00:00 and the customer works our 5 hours the finish time will be 01:00:00 (1:00am).

How do I add the amount of hours to my allready exising time?

By the way the following doesn't work:

echo date("g:i a", mktime(date("h", strtotime($r['start_time']))+$hours, 0, 0, 0, 0, 0));

Can anybody help?

planetsim

There isnt much to go on but your example that doesnt work maybe try this

echo date("g:i a", mktime(date("h", strtotime($r['start_time']))+($hours*3600), 0, 0, 0, 0, 0));

discostudio

na, that dosn't work.

I'm starting to think I'm way off track and this is not the way to do it.

Anyone a date() and mktime() expert on here?

Weedpacket

$start_time = strtotime($r['start_time']);
// and if $r's values are coming out of a database,
// consider using any functions your
// dbms provides to convert to Unix
// timestamps within the query

$end_time = strtotime('+5 hours',$start_time);

echo date('g:i a', $start_time),"<br>",date('g:i a ', $end_time);

discostudio

Well, thats excellent because that works.

But....

I need to be able to work out, say 2 and 1/2 hours as a 2.5 decimal.

So I would do

8pm +2.5 = 10:30pm and the decimal is all I have, so I can't add:

hour+2
minute+30

I need to simply do

8pm +2.5

This is starting to make my head hurt..... :queasy:

😕

Installer

How about:

$minutes = 2.5 * 60;
$end_time = strtotime('+' . $minutes . ' minutes', $start_time);

discostudio

Originally posted by Installer
How about:
$minutes = 2.5 * 60;
$end_time = strtotime('+' . $minutes . ' minutes', $start_time);
[/B]

LOL, Why didn't I think of that.

Thanks. 😃