Time Difference

Ram_Gopal_Rao · October 19, 2016, 2:40pm

How to get difference of two time fields?

Please help.

vjFaLk · October 19, 2016, 3:15pm

This is more of a python problem, you’re better off doing a Google search for this, but there are functions in frappe that allows you to do this easily.

github.com

frappe/frappe/blob/develop/frappe/utils/data.py#L103


      
          
          
	if is_invalid_date_string(string_date):
          		return None
          	try:
          		return parser.parse(string_date, dayfirst=parse_day_first).date()
          	except ParserError:
          		frappe.throw(
          			frappe._("{} is not a valid date string.").format(frappe.bold(string_date)),
          			title=frappe._("Invalid Date"),
          		)
          
          

          
def get_datetime(
          	datetime_str: Optional["DateTimeLikeObject"] = None,
          ) -> datetime.datetime | None:
          	from dateutil import parser
          
          
	if datetime_str is None:
          		return now_datetime()
          
          
	if isinstance(datetime_str, (datetime.datetime, datetime.timedelta)):

Import the functions like : from frappe.utils import time_diff

Ram_Gopal_Rao · October 20, 2016, 7:00am

Can we create custom Script to calculate time difference.

Please help.

ravindra_l · October 20, 2016, 1:05pm

yes you can create a custom python script and import time_diff as suggested by @vjFaLk

Ram_Gopal_Rao · October 21, 2016, 5:38am

Ravindra, Can you please send the written code, so that I can paste it in custom script(client).

I’m really weak in coding and all.

shraddha · October 21, 2016, 5:59am

Hi,

Try with this,

from frappe.utils import time_diff_in_hours
Example:-
diff = time_diff_in_hours(“05:22:00”, “14:30:14”)
Print diff

Ram_Gopal_Rao · October 21, 2016, 6:10am

I have written code like below.

frappe.ui.form.on(‘Issue Case History’, ‘validate’, function(frm){

from frappe.utils import time_diff_in_hours

var diff;

diff=time_diff_in_hours(frm.doc.end_time, frm.doc.start_time);

cur_frm.set_value(“total_time”, diff);

});

Note: here “Issue Case History” is a child table to “Issue”.

This code is not working for me.

Kindly help.

Ram_Gopal_Rao · October 21, 2016, 7:32am

@shraddha

Ram_Gopal_Rao · November 25, 2016, 11:20am

We are using cloud based ERPNext.

So is it possible to use these python scripts in client side custom scripts? below code doest
work. Please help.

frappe.ui.form.on(“Issue Case History”, “start_time”, function(frm, cdt, cdn) {
var z = locals[cdt][cdn];

from frappe.utils import time_diff_in_hours
z.total_time=time_diff_in_hours(z.end_time, z.start_time);
cur_frm.refresh();

});

nabinhait · November 27, 2016, 10:52am

Create a custom script report for document “Issue” and use following code there:

frappe.ui.form.on("Issue Case History", "start_time", function(frm, cdt, cdn) {
	var z = locals[cdt][cdn];

	if(z.start_time && z.end_time) {
		total_time = frappe.datetime.get_hour_diff(z.end_time, z.start_time);
		frappe.model.set_value(cdt, cdn, "total_time", total_time);
	}
});

rahy · March 24, 2019, 8:35am

I use this code to calculate the time difference

frappe.ui.form.on('Attendance', {
refresh: function (frm, cdt, cdn) {
    var d = locals[cdt][cdn];
    console.log(cdt, cdn, d.time_in, d.time_out, d.total_hours);

    if (d.time_in && d.time_out) {
        var total = frappe.datetime.get_hour_diff(d.time_out, d.time_in);
        console.log(total);
        
        frappe.model.set_value(cdt, cdn, 'total_hours', total);
        console.log(d.time_in, d.time_out, d.total_hours);
    }
}
});

It returns NaN for the total.
If I don’t use var for total (as in your code), it returns undefined in the console.

Can you please tell me where I do wrong?
Thank you

rahy · March 24, 2019, 8:41am

After press enter to post previous message, I was thinking about changing the field format (previously they use Time).
So I changed it to Datetime (all 3: time_in, time_out, total hours) and it calculates. Even if it’s wrong.

In the console the total_hours returns 7. And this

Another try. Use time_in as Datetime, time_out as Datetime, and total_hours as Time. Now it calculates hours correctly.

So I was wondering if the get_hour_diff is working as it should be.

Secondly, how do I calculate the minute as well?

Thank you

Sayem_NazTech · February 20, 2020, 11:31am

I use this code for calculate Total Working Hours.
NB: Use time_in as Time, time_out as Time, and total_hours as Float Type

frappe.ui.form.on('Attendance', {
refresh: function (cur_frm, cdt, cdn) {
    var d = locals[cdt][cdn];
    console.log(cdt, cdn, d.in_time, d.out_time, d.total_working_hours);

    if (d.in_time && d.out_time) {
        var in_times = parseFloat(cur_frm.doc.in_time);
        var out_times = parseFloat(cur_frm.doc.out_time);
        var total = parseFloat(out_times - in_times);
        console.log(total);
        
        frappe.model.set_value(cdt, cdn, 'total_working_hours', total);
        console.log(d.in_time, d.out_time, d.total_working_hours);
    }
}
});

TWH

Heretocode · January 28, 2022, 2:24pm

Hey Guys i want to calculate total time a person spends on a form. i.e from time form is loaded till the form is submitted. So how can i get start time of the form and whats the best way to approch this problem.