Hi,
I'm converting minutes to display as HH:MM but have an issue when the number is negative. Anyone know how to write this so I don't end up with a negative in front of the minutes?
Format([Variance]\60,"00") & ":" & Format(([Variance] Mod 60),"00")
i.e. -193 gives me -03:-13, whereas I would like -03:13
Thanks,
Ryan
I'm converting minutes to display as HH:MM but have an issue when the number is negative. Anyone know how to write this so I don't end up with a negative in front of the minutes?
Format([Variance]\60,"00") & ":" & Format(([Variance] Mod 60),"00")
i.e. -193 gives me -03:-13, whereas I would like -03:13
Thanks,
Ryan