![]() |
Time calculation.
hi to all
While feeding our production reports we can punch starting time & ending time ( Clock time ) of the activity & we want the time duration to be calculated in mins. Pls. help me. ****al shah |
=(B1-A1)*24*60
HTH Jason Atlanta, GA -----Original Message----- hi to all While feeding our production reports we can punch starting time & ending time ( Clock time ) of the activity & we want the time duration to be calculated in mins. Pls. help me. ****al shah . |
Jason Morin
thanks for reply it come as numbers i want in time formate like HH:MM i have in b1=7:55 a1=6:30 it come 85 i want 1:25 ****al "Jason Morin" wrote: =(B1-A1)*24*60 HTH Jason Atlanta, GA -----Original Message----- hi to all While feeding our production reports we can punch starting time & ending time ( Clock time ) of the activity & we want the time duration to be calculated in mins. Pls. help me. ****al shah . |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com