[Ramses99]

Hey everyone.

This is probabily a simple issue, with a some-what simple solution...
I'm trying to put together a MySQL table(s) where I can insert the times I punch in and out of work and be able to calculate total time 'working'.

I'm not sure exactly how to go about doing this. Any ideas or thoughts would be very much appreciated.

Thanks.

[nova912]

ok ill brain storm a lil bit

lets do military time

PHP Code:

$inhour = date(H)

$inmin = date(i)



$outhour = date(H)

$outmin = date(i)



if ($inhour < $outhour){$hours=$inhour-$outhour;}else{$hours=$outhour-$inhour;}

if ($inmin < $outmin){$mins=$inmin-$outmin;}else{$mins=$outmin-$inmin;}

$time = $hours.':'.$mins



echo "You have worked".$time." today."; 

than just add the MySQL element /shrug ... that how i would base it.. problems i see are if you punch in at 23:50 and punch out at 8:50 =/

[Ramses99]

I like that.... that would work quite well.... Would have to revamp it a bit for the lunch break.. but over-all I think it would work. Actually doing it this way would make things much easier from the MySQL end of things... just store the total work times for each week/month or whatever. Yes... that will work...

problems i see are if you punch in at 23:50 and punch out at 8:50 =/

How did you know???? Ya, I work nights so that would be an issue. Easily solved by adding another area with which I could enter the amount of min that are not covered by the initial time-in.

THANKS

[nova912]

I just thought that was a simple way of doing it im not sure if it will work ( i did not run the code) but it should work with some tweaking

i'm glad i could contribute

[<?Wille?>]

why dont just store unix timestamp with time() and calculate from there?