Results 1 to 4 of 4

Thread: date help please

  1. #1

    date help please



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Subject Start Date Start Time End Date End Time All Day Event Description Location
    1098 21/07/2014 14:11 21/07/2014 19:51 FALSE 5h10
    RD 22/07/2014 22/07/2014 16:05 TRUE RD
    1128 23/07/2014 16:57 23/07/2014 00:29 FALSE 7h02
    1116 24/07/2014 15:23 24/07/2014 00:43 FALSE 8h50
    This is my table above
    the end time is after midnight how do I add a day to the end date

    Many thanks in advance

  2. #2
    =(c4,if(f4>"00:00"+1))
    anybody ?

  3. #3
    Good morning,

    One note, on your times that are after midnight the dates should be increased. Currently the end times are before the start times. To figure hours worked use:

    = ( (End Date + End Time) - (Start Date + Start Time) ) * 24

    Hope this helps,

  4. #4
    Try

    =C2+(D2>F2)

Posting Permissions

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