Hi!
We have 2 different systems for workforce management/scheduling and HR/salary at my company.
The WFM system (blue cells in the attached example) uses a format where 1� hours is formatted as 1,30 (Ill call this minute format)
The HR system uses (green cells) a format where 1� hours is formatted 1,50 (Ill call this decimal format)
The difference (orange cells) is simply System 2 - System 1.
So far I've manually edited the HR column so they're both in minute format by calculating it manually with a decimal to minute converter.
Is there any way to make a formula that makes the difference show up in minute format?
Best regards
Lasse
Bookmarks