Consulting

Results 1 to 4 of 4

Thread: calculate 2 datetime and returning to days and hours

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Apr 2014
    Posts
    2
    Location

    calculate 2 datetime and returning to days and hours

    excelforum.com/excel-programming-vba-macros/1007908-calculate-2-datetime-and-returning-to-days-and-hours.html#post3680311

    1st question :
    let see if textbox1 is date and time in, textbox2 is date and time out, textbox3 is calculate the days and hours. problem is the calculation is ok but when i put 25/4/2012 10:00 in textbox1 then textbox2 i put 26/4/2012 9:00 the answer should be 23:00 not 01:00. how to get exactly 23:00


    2st question : in textbox4 should be only the days but i get 0.958333333335759 and suppose it show o and in textbox5 it will show 23 hours


    3rdquestion : in textbox6 and textbox7 is manually put amount to be charge and it will auto calculate at textbox8.


    here i attach my file for better review. sory im still new n still learning


    THANKS IN ADVAND
    Attached Files Attached Files
    Last edited by remie; 04-30-2014 at 11:31 PM. Reason: cross posting

Posting Permissions

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