ExcelBanter - Nita Time formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Nita Time formula (https://www.excelbanter.com/excel-worksheet-functions/257505-nita-time-formula.html)

Doug AllPool

Nita Time formula

This was a reply to nita.

Are all the cells formatted for time? I have them all formatted for time
(13:30) and
I get " #VALUE! " in the cell with the formula.

Doug

Fred Smith[_4_]

Nita Time formula

Keep your responses in the original thread, otherwise people don't know what
you are talking about.

Regards,
Fred

"Doug AllPool" wrote in message
...
This was a reply to nita.

Are all the cells formatted for time? I have them all formatted for time
(13:30) and
I get " #VALUE! " in the cell with the formula.

Doug

All times are GMT +1. The time now is 08:03 PM.