ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/92636-time-calculation.html)

sjl

Time Calculation
 
How do i format and calculate the time say for example 6/5/06 at 3:30 pm to
6/6/06 4:35 pm?

Thanks, sjl

David Biddulph

Time Calculation
 
"sjl" wrote in message
...
How do i format and calculate the time say for example 6/5/06 at 3:30 pm
to
6/6/06 4:35 pm?


=A2-A1, and format as [h]:mm, or whatever you prefer.
--
David Biddulph




All times are GMT +1. The time now is 12:43 AM.

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