| 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 | |||
Hybrid Mode
