Results 1 to 2 of 2

Thread: Calculate work hours

  1. 11-17-2009, 01:13 AM #1
    varmacorp
    varmacorp is offline Registered User
    Join Date
    Nov 2009
    Posts
    1

    Calculate work hours

    I have a table with a date time column which actually stores the data as and when it is inserted. I need to calculate the time the machine has worked hourly wise. For example the table contains records from 13:00 to 13:15 and 13:45 to 14:00 i should get 30 mins as working time....
    Reply With Quote Reply With Quote
  2. 11-17-2009, 06:22 AM #2
    aklein2003's Avatar
    aklein2003
    aklein2003 is offline Registered User
    Join Date
    Nov 2009
    Posts
    2
    Hi Varmacorp,
    Can you explain what is the relation between the consecutive datestimes?
    Maybe post more examples, like "What times don´t you consider a valid interval"..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules