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
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)
Hi,
I try to calculate a duration through a simple substract between two time (not datetime case) format HH:mm:ss, Fx : format([theo_hour]-[Real_hour], ‘HH:mm:ss’) I followed this topic but I have error msg ‘’ #Can’t subtract not numbers’’
help pls
The error indicates that in [theo_hour]-[Real_hour] either the left or the right part is not a number in some row. Make sure that both [theo_hour] and [Real_hour] are numbers before subtracting them. If needed, use the “Convert data types” action to convert text dates into numbers.