Excel 2007. Challenge: I have a calculated value in [h]:mm-format "37:00"
(summing up the number of worked hours for a month) and a single value in
general format "80" (the total number of expected working hours for the
month).
I need to calculate the difference via a formula. I having "=g34-e40" for
the "80 minus 37:00" which should be 43. But obviously the two formats makes
a value of either "#############" or "-78.46", depending on the format of the
resulting cell.
Have tried with the CONVERT and INT-function, but no luck...
"=(G34-INT(G34))*24" made my 37:00 comes to 13, but not 37 (a difference of
24 hours though)
Can You assist ?