+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 27 of 27

tijd registratie na 2400 uur

  1. #16
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Hmm i tried to change the cell. I did right mouseclick then cell and change it to date 14-03-2018. Or do i change it into dd-mm-jjjj?
    Or do you mean the time?
    I tried different options in the change but if i make it time and i fill in (date time) it display date and time in a cell that is ment for only time.
    Or do i haven to delete data in the cells before i can edit the charaterics?
    In the form i'am gonna hide the coulored cells.

  2. #17
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,696

    Re: tijd registratie na 2400 uur

    Change t to whatever you want the customer to see.

    If you only want them to see the time them UU:MM

  3. #18
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Yeah okay, but i have 3 to 5 forms a day, so i don't wanna change every form when i'am home. I fill the form on my phone, when i'am home i print the form and book the hours, then i print the customer and tour details on the form (this is automaticly done in my accountacy program) and send the form with the invoice to the customer by email. I have the form secured so i can only fill in the dates i need. The customer gets a scan of the form. So change afterwards is no option.

    Thats why my question was if it's possible to change the format you see in the form. Like dd-mm-jj uu:mm or something, mayby it looks a little bit less cloutered otherwise it's mayby a lot of information
    I have to design a whole new form so i can make it look how i want.

  4. #19
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,696

    Re: tijd registratie na 2400 uur

    You don't have to change it again after, just format it as uu:mm

    You can enter date and time, but only the time will show. The date will still be there but you will not see it.

    If you want to format as dd-mm-jj uu:mm then you will have to change every one individually!

  5. #20
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Hmm what do i wrong?
    I change a cell when it's filled in uu:mm then you see the time and when you click on it the date and time is shown in the topbar.If i clean the cell of date and fill it new as 22:00 it's show 22:00, if i fill in 14-03 22:00 then it'shown in the cell. I tried to change the format in a clean cell as well.

  6. #21
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,696

    Re: tijd registratie na 2400 uur

    Try it with conditional formatting instead.

    Use a formula to determine which cells to format, in the formula box enter

    =WAAR

    Then set the fomat as uu:mm on the 'number' tab of the formatting box.

  7. #22
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Hmm or i don't understand you or it doesn't work. The cells where i just wanna see uu:mm don't have a formula. That are the cells that i fill in with time of start stop or loading Cells C2:C5 and cells B7:E9 in the form named testnieuw i attached as last form.

  8. #23
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,696

    Re: tijd registratie na 2400 uur

    Condtional formatting is something in the background, it is typically used to change the colour of a cell to highlight things that meet specific conditions, but it has other uses as well.

    My translation tool doesn't work for menu items, I've given the exact path to follow in english, hopefully it will be enough for you to follow.

    Select the cells(s) where you want to enter the date and time but only want to see the time.

    On the excel ribbon, go tot he 'Home' tab, then look for 'Conditional formatting' > 'New rule' > 'Use a formula to determine which cells to format'.

    Enter =WAAR in the formula box on the popup, then click the 'Format' button.

    Go to the 'Number' tab, then set the appropriate format here, uu:mm

    Click the 'OK' buttons on all of the boxes.

  9. #24
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Okay wonderfull it works. thank you. I preciate your help, it wasn't simple.
    Is this now only in this form? or in options for excell?
    Hmm after testing still one thing. Wenn I fill the cell B2 with a date 14-03-18 and C2 is 14-03-18 23:00. if C3 filled with 15-3-18 01:00. i would like that cells b3:B5 are automaticly filled with the next date. Of course if C4 is overnight the date change in B4.

    In the old form i used the formula =ALS((C3<C2);B2+1;B2) but that doesn't work anymore

  10. #25
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    I figured it out. Because i use the date and time in cel C3:C5, shown as time. Thanx for the solution.
    Did the same thing in De cells B2:B5 for the date. The formule is now in B2 (=C2) it display the date in B2.
    This also goes for de rest of the cells.
    Still wanna thank you for your help.
    If your in holland email me and we're gonna drink some cognac or whisky.
    Last edited by langeloo; 09-26-2018 at 03:34 PM.

  11. #26
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Hi Jason hmm i found't something that i wanna change but don't know how.
    I have got the fromula =SOM(C3-C2;1)-SOM(F13:K13) it display a time of 1 h and 30 m. I wanna change this in 1.5 H.
    Tried to multiply the formula with 24 but that didn't work. Looked up on internet and found something as (integer) but i still can't figure it out.

    Posible of course this is realy simple. Changed the cell as you discribed conditional formating.

  12. #27
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    2016
    Posts
    16

    Re: tijd registratie na 2400 uur

    Sorry i found it. Nee to make the formule in another cell. at least thanx

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

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