ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR . (https://www.excelbanter.com/new-users-excel/63769-need-formula-calculate-difference-between-two-times-24hr.html)

teezee

NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR .
 


Bob Phillips

NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR .
 


--

HTH

RP
(remove nothere from the email address if mailing direct)


"teezee" wrote in message
...




Bob Phillips

NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR .
 
=A2-A1

and format as time

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teezee" wrote in message
...





All times are GMT +1. The time now is 06:38 PM.

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