All date and time values are numeric values just formatted differently, with the amount calculated in days, and 0.5 for example is 12 hours. To obtain the result in minutes you can either multiply by 24*60 (in your example `=K486*24*60`

or `=K486*1440`

), or format the result with `[MM]`

note the [] brackets for duration. Note also that your calculation may produce a negative value, which you don't see with a `HH:MM`

clock format.

However, your formula probably is not what you want to achieve, as the result of NOW() is a date+time value (since null date 1899-12-30) and right now `=TIME(17;0;0)-NOW()`

unformatted gives -43747.0778472367 or -62995792.1000209 minutes..

If you use NOW() you have to subtract two full date+time values like

```
=DATE(2019;10;9)+TIME(17;0;0)-NOW()
```

or

```
=TIME(17;0;0)-(NOW()-TODAY())
```