[End User]

I've searched all over and can't find any code that provides the difference between to sets of hours and minutes....here's what I'm trying to do....

For example, a user is supposed to get 50 hours and 30 minutes of account time:

50:30

But in fact he only gets 45 hours and 42 minutes:

45:42

How can I find the difference in in hours and minutes (that is, 4 hours and 18 minutes)?

I've looked at all sorts of stuff with strtotime, strfromtime, and about a billion lines of code examples but I've yet to find anything that simply subtracts one set of hours and minutes from another set of hours and minutes. I have a terrible feeling that this is really, really simple, but the problem is that *I'm* also really, really simple and I just can't see it.

[mab]

You can actually use strtotime() (assuming you want to show a date/time so many hours:minutes relative to some starting/current date/time), however strtotime() does not directly accept the HH:MM (or HH:MM:SS) format in any math (+/-) statements. But if you break it up and do something like the following, it works -

PHP Code:

strtotime("now + 50 hours + 30 minutes") 

Edit: Here is some code I just did for someone where the difference between two HH:MM were calculated -

PHP Code:

$from = '08:31' ; 

list($hours,$minutes) = explode(":",$from);

$to = '16:30' ;  

$output = date("H:i",strtotime("$to - $hours hours - $minutes minutes"));

echo $output; 

[Jay6390]

I'm guessin you could code it to work it out. Are you just hoping someone knows a quick way around it End User?

[End User]

Originally Posted by mab

Edit: Here is some code I just did for someone where the difference between two HH:MM were calculated -

PHP Code:

$from = '08:31' ; 

list($hours,$minutes) = explode(":",$from);

$to = '16:30' ;  

$output = date("H:i",strtotime("$to - $hours hours - $minutes minutes"));

echo $output; 

Thanks, mab, I'll try this and see if I can get t to work- the one problem I'm running into (well, one of the problems, lol) is that either time can be larger or smaller...that is, the times could be like this, shown in time in hours and minutes:

50:35 (50 hours, 35 minutes scheduled time)
42:29 (42 hours, 29 minutes actual time)

Or they could be like this

47:16 (47 hours, 16 minutes scheduled time)
59:24 (59 hours, 24 minutes actual time)

The number are a count of the hours and minutes they were scheduled for and what they actually got, and the number they got can be more or less than they were scheduled to receive. (For example, they could be scheduled for 5 hours and only get 2 1/2, or they could be scheduled for 5 hours and actually get 12.)

So, I need to be able to find the difference, and whether it was positive or negative (did they more or less actual time than was scheduled).

I'll try this and see if I can get t to work.

[End User]

Originally Posted by Jay6390

I'm guessin you could code it to work it out. Are you just hoping someone knows a quick way around it End User?

More like praying or groveling. I've been beating my head against the wall on this and the wall is starting to win.

[Jay6390]

Ok, well here is a very VERY messy but working script lol. you will need to clean it up a bit me thinks but u shud get the general idea of what it does

PHP Code:

<?php
$from = '50:30' ;
list($hours,$minutes) = explode(":",$from);
$totalfrom = $minutes +(60*$hours);
$to = '45:42' ;
list($hours,$minutes) = explode(":",$to);
$totalto = $minutes +(60*$hours);
$diff = $totalfrom - $totalto;

$neg = ($diff<0)?'-':'';
$diff = abs($diff);
$diffhrs = intval($diff / 60);
$diffmins = $diff &#37; 60;


echo "DIFFERENCE: {$neg}$diffhrs:$diffmins";

?>

Oh, and your original post, the difference is 4:48 not 4:18
Hopefully your head will start winning the competition now against the wall lol

EDIT: The $diffmins line should be $diffmins = $diff % 60 but for some reason its not parsing it correctly

Jay

[End User]

Thank you, Jay! I think this is very close to what I'm looking for. Let me play with this for a bit and I'll come back and report the current condition of the wall, lol.

[Jay6390]

Originally Posted by End User

Thank you, Jay! I think this is very close to what I'm looking for. Let me play with this for a bit and I'll come back and report the current condition of the wall, lol.

*at the ready with polyfiller*

[End User]

Originally Posted by Jay6390

*at the ready with polyfiller*

Lol.

My head was just too fuzzed to think clearly, but that code worked and I thank you for it.

[Jay6390]

Originally Posted by End User

Lol.

My head was just too fuzzed to think clearly, but that code worked and I thank you for it.

hehe, no problem