ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   working with time in minus (https://www.excelbanter.com/excel-worksheet-functions/92597-working-time-minus.html)

Huong Son

working with time in minus
 
I have a calculation like this (7/6/2006 6:10 AM) - (7/6/2006 6:20 AM) =
#######
How can i sole this problem


Bob Phillips

working with time in minus
 
You could switch to 1904 date system, ToolsCalculate1904 date system

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Huong Son" <Huong wrote in message
...
I have a calculation like this (7/6/2006 6:10 AM) - (7/6/2006 6:20 AM) =
#######
How can i sole this problem





All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com