ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time calculation. (https://www.excelbanter.com/excel-worksheet-functions/9333-time-calculation.html)

shital shah

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

Jason Morin

=(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
.


shital 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 11:39 AM.

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