Results 1 to 5 of 5

Time between 2 dates and times

Threaded View

realniceguy5000 Time between 2 dates and times 02-16-2012, 03:27 PM
Paul Re: Time between 2 dates and... 02-16-2012, 03:59 PM
realniceguy5000 Re: Time between 2 dates and... 02-17-2012, 11:49 AM
OnErrorGoto0 Re: Time between 2 dates and... 02-17-2012, 11:54 AM
realniceguy5000 Re: Time between 2 dates and... 02-17-2012, 12:02 PM
  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Time between 2 dates and times

    Hi, I have a col with pick dates (K) and a col with pick times(J) I want to find the how much time it took the picker to pick all the orders in a week.

    Trying this:Getting a type mismatch error

    
    StartDay = Cells(22, "K") 'small date
      stime = Cells(22, "J")    'start time
    EndDay = Cells(lrow, "K") 'large date
      etime = Cells(lrow, "J") ' end time
     
    Results = DateDiff("h", StartDay & " " & stime, EndDay & " " & etime)
    Can someone advise, thank you Mike
    Last edited by realniceguy5000; 02-17-2012 at 12:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1