Time and formulas and errors

[Shane10326]

Hello, I need some help with an error I can't get around, it seems pretty simple but I can't figure out why I keep getting the #### error.

I want to manually enter two times and have the rest calculated automatically, no VBA no Macro.

I have tried changing the cell format and a few other things please let me know what can be done.

[#2]

@Shane10326 

You should enter the date and time in the Time Raised column.

The Time Open and SLA Time columns should be formatted as [hh]:mm, not as clock time.

And I think the formula in CountDown Timer should be =1440*([@[Fail Time]]-NOW()) to display the number of minutes left. You cannot use a time format here since the result will be negative when the Fail Time has passed.

 

[#3 · Accepted solution]

@Shane10326 

Use MOD(NOW(),1) instead of NOW()

[#4]

THANKS FOR THE REPLY!!

[#5]

This worked a dream thank you

[#6]

@Shane10326 , you are welcome