Caluclations in time and form fields

[GoKats78]

I am trying to devlop a form, using form fields, that will calculate hours worked based on inputs in fields. I cannot get the calculations to return the correct hours worked...

For example, I enter 6:00 in Mon In and 14:30 in Mon_out - the resulting calcualtion, =(mon_out)-(mon_in), returns 26.00


What's going on?

[GoKats78]

I thought I had it...until I added "Minutes" to the equation..


I uploaded an updated sheet...

[fumei]

Hmmm. If I put in 6:30 in Mon_in and 14:30 in Mon_out, it shows as 8:00.

However, changes to your fields can get odd. You may want to add something that will update your calculation fields.