About EasyMorph Tutorials & Examples Web-help

Date / Hour Difference issue


#1

Hi,
Based on a real case, I try to calculate a duration through a simple substract, but I got strange results from time to time.
The begin and end hours are typed in Excel in a time format : hh:mm:ss
Duration%20issue%201

After import in EasyMorph, I’ve got the following issue
18:00:00 - 17:30:00 = 12:30:00 (and not 0:30:00 as expected)
empty - empty = 12:00:00 (and not 00:00:00)

Any idea?Test Planning.xlsx (11.1 KB)
Duration issue.morph (2.2 KB)


#2

Hi Michel. Use format HH:mm:ss (24-hour) instead of hh:mm:ss (12-hour).


#3

Thanks Dmitry!!! Work perfectly now.

Anyway, strange result with the 12 hours formatting…

Have a good day :slight_smile: