In message <D2492F6ED6E4425B97F2B8D8A6CF65E0@xxxxxxxxx>, Michael Reaves <mreaves@xxxxxxxx> writes >Group, > > > >I have 3 times in a mysql database. Start time, end time and amount of time >spent at lunch. All are in a time field. How can I figure the daily time, >end-start-amount time spent at lunch, with php? SELECT TIMEDIFF(TIMEDIFF(timeend,timestart),lunch) FROM mytable -- Pete Clark Advertise your events in Spain - local and free http://hotcosta.com/events.php
