With time in A1 ...for 21:47 ...

=(HOUR(1-A1)+MINUTE(1-A1)*0.01)*-1

For 02:43 ...

=HOUR(B1)+MINUTE(B1)*0.01

With I assume some test (IF condition) if time is before or after MIDDAY?


"Mai-Britt" wrote:

How do I convert time of day to time according to midnight? Ex. 21:37 to
-2,23? Or 02:43 to +2,43? Midnight is defined as 0.