| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time calculation
Sir,
Pl help me calculate the hours. I have two col A & B A B C Time In Time Out Working Days 17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours 17:00 15:00 p.m. (next days) = 22 hpurs how i can apply formula. RKS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time calculation
Either
=B2-A2+(B2<A2) or =MOD(B2-A1,1) -- David Biddulph "RKS" wrote in message ... Sir, Pl help me calculate the hours. I have two col A & B A B C Time In Time Out Working Days 17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours 17:00 15:00 p.m. (next days) = 22 hpurs how i can apply formula. RKS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
time calculation
=MOD(Time Out - Time In,1)*24
e.g. =MOD(B2-A2,1)*24 Format cell as General HTH "RKS" wrote: Sir, Pl help me calculate the hours. I have two col A & B A B C Time In Time Out Working Days 17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours 17:00 15:00 p.m. (next days) = 22 hpurs how i can apply formula. RKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
| TIME CALCULATION | Excel Discussion (Misc queries) | |||
| Time Calculation | Excel Worksheet Functions | |||
| Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
| time calculation with military time | Excel Worksheet Functions | |||
Linear Mode
