Time calculations Urgent please help
jahoobob Wrote: In your illustration, if 22:00 is in A1 and 02:00 is in B1 then this formula will get your desired reslut: =IF(A1B1,((B1-A1)*24)+24,(B1-A1)*24) Thank you very much -- colt |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com