timespan - VB.net Get total time between two time spans -


i wondering if there function vb.net can tell me total time 2 different time spans have in common.

for example, have these 2 different time spans: 

1st date : (2013-01-01 8:30 am) - (2013-01-01 11:30pm) 2nd date : (2013-01-01 10:00 pm) - (2013-01-02 6:00 am)

can vb.net tell me answer 1 hour , 30 mins? (perhaps in decimal) 1 hour , 30 minutes because 10:00pm in evening , 11:30 in evening falls in other time span.

summary:

i need function tell me how many hours in timespan part of night shift. (that's 10:00 pm 6:00 am).

date1 , date2 represents first time span , date2 , date3 represent second time span. if order of dates changed have define analogous else first if. 

    dim date1 date = #1/1/2013 8:30:00 am#     dim date2 date = #1/1/2013 11:30:00 pm#     dim date3 date = #1/1/2013 10:00:00 pm#     dim date4 date = #1/2/2013 6:00:00 am#     dim timeperiod timespan      if date3.date >= date1.date , date3.date <= date2.date         if date4.date <= date2.date             timeperiod = date4.timeofday - date3.timeofday         else             timeperiod = date2.timeofday - date3.timeofday         end if     end if     msgbox(timeperiod.tostring)

edit: timeperiod = date4- date3 convert difference timespan

edit 2:the code above have returned date2-date3 if there there no common time span. code below return 0 in such case. when comparing 2 date variables in if statement, timeofday part neglected.

        dim date1 date = #1/1/2013 8:30:00 am#         dim date2 date = #1/1/2013 11:30:00 pm#         dim date3 date = #1/1/2013 10:00:00 pm#         dim date4 date = #1/2/2013 6:00:00 am#         dim timeperiod timespan         if date3 >= date1 , date3 <= date2             if date4 <= date2                 timeperiod = date4 - date3                               elseif date3 < date2                                    timeperiod = date2 - date3             elseif date3.date = date2.date                                     if date3.timeofday < date2.timeofday                                             timeperiod = date2 - date3                 else                 timeperiod = timespan.fromdays(0)                 end if             else                 timeperiod = timespan.fromdays(0)             end if         end if         msgbox(timeperiod.tostring)

Comments

Post a Comment

Popular posts from this blog

SPSS keyboard combination alters encoding -

my question not have programming practical issue on spss. accident keyword combination cannot remember because did not intend press changed encoding in spss , text in data in different language english shown small boxes. nevertheless, when kind of analysis performed different language text shown in output. does know reason? tried change encoding did not produce result. first, @ edit > options , see whether setting unicode or locale. might fix it. if have text in multiple languages, want unicode. otherwise, may have specific locale set wrong. can change set locale, need know locale want use.
Read more

Add new record to the table by click on the button in Microsoft Access -

in ms access form want implement separate button, adds new record table. in order added button , attached button event: private sub btnaddrec_click() refresh codecontextobject on error resume next docmd.gotorecord , , acnewrec if err.number <> 0 btnaddrec.enabled = false end if end end sub everything ok when open window , click btnaddrec button, problem when first of perform navigation through existed records , after click on button. got runtime error: 2105: «you can't go specified record. may @ end of recordset» . how solve issue, need have ability add new record on click on specific button, no matter, have walked or not walked through records before. thanks. i created simple form field call description (and autonumber) , created button code follows click event. filled number of records , navigated through them, clicked addnewrec button. form navigated new record without issues. able click addnewrec button directly after
Read more

javascript - jQuery .height() return 0 when visible but non-0 when hidden -

i have problem here right opposite others: in jquery cannot height of element when it's visible, when hidden. have html code: <div id="filtering-filter-holder"> <div id="filtering-filter-holder-inner"></div> </div> basic css it: #filtering-filter-holder { display: none; position: absolute; width: 420px; min-height: 100px; padding: 5px 5px 5px 5px; background-color: #ffffff; border: 1px solid #164372; } and finally, js in document.ready(): $('div.filtering-filter-headline').mouseenter(function() { var el = $(this).parent().find('div.filtering-filter-content'); if ($('div#filtering-filter-holder').is(':visible')) { $('div#filtering-filter-holder-inner').stop(true, true).fadeout(300, function() { $('div#filtering-filter-holder-inner').html($(el).html()); var height = $('div#filtering-filter-holder-inner&#
Read more