Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=(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 . |
#3
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
elapsed time calculation | Excel Discussion (Misc queries) | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions | |||
Excel - Time calculation | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |