Power Platform Community Forum Thread Details

I want to capture the time between clicking on the Add icon to add a new item and clicking on the submit button.

so inside the Add icon onselect i added this formula:-

Set(currentDatetime,Now());Navigate(FormsCRUD);
 
and i set the default value for the StartTime  (which is a datetime sharepoint field) to be :-
 
If(ThisItem.'Start Time'=Blank(),currentDatetime,ThisItem.'Start Time')
 
then inside the submit button i added this formula:-
 
Set(submitdatetime,Now());
SubmitForm(Level1Form);
ResetForm(Level1Form);

and i set the default value for the endtime (which is a datetime sharepoint field) to be :-

If(ThisItem.'End Time'=Blank(),submitdatetime,ThisItem.'End Time')

now if the time between the 2 dates is only 2 minutes, i will get the differences to be around 2.5 hours. starttime will be 11:36 pm while endtime will be 9 pm!! any advice?

Thanks