Time display properly

[kiewan]

Hello,

Please Login or Register  to view this content.

When using the formula the time is sometimes dispayed as -00:00 while it should be 00:00. what is causing this?
I have added my sheet in the attachment.

Regards,
Kiewan

[LeoTaxi]

Column P you have different cell formats

Kind regards
Leo

[MarvinP]

Hi kiewan and welcome to the forum,

I believe this is simply a rounding error while using binary math. Zero and -Zero are the same (you know this). But in computers that need to use 16 digits of accuracy it might be just negative.

[Root_]

@Kiewan:

It's a rounding issue. To address it, try placing the following formula in cell O3 and drag-copying it down as needed:

=MROUND(E3+G3+I3+K3+M3+R3+N3,"0:01")

[kiewan]

@Kiewan:

It's a rounding issue. To address it, try placing the following formula in cell O3 and drag-copying it down as needed:

=MROUND(E3+G3+I3+K3+M3+R3+N3,"0:01")

This fixed the issue, thanks. What is the function of the 0:01?

[Root_]

You are welcome.

MROUND(time_value,"0:01") rounds the time_value to the nearest minute.