Calculation with minus times in time format

[neapicture]

Hello, I have to do an overtime evaluation and get a file with raw data. Unfortunately, the field hour is in text format (shown only as a time format) and there are also minus hours.

I have to make a buzz. Now probably the value would first have to be converted into decimal in order to be able to count / sum on the minus times. If possible, the result should again be in time format (hh: mm). (alternatively decimal).

Unfortunately, I do not really get the formula right.

[shiveshsingh]

What do you mean by this value?

177:10

[neapicture]

The employee has 177 hours and 10 minutes of overtime on his working time account

[shiveshsingh]

and what this suggests?

-07:04

[neapicture]

Well, the employee has 7 hours and 4 minutes minus in the account, so 7 hours too little worked

[lorenzoconforti]

Please see the attachment. I've converted it to number of hours

I don't think you can have it expressed as hh:mm as time cannot be negative

[PrashantSangle]

Hi,

what is your expected output.

Regards