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.

Change t to whatever you want the customer to see.

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

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.

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!

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.

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.

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.

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.

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

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.

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