ExcelBanter - time calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - time calculation (https://www.excelbanter.com/excel-discussion-misc-queries/134293-time-calculation.html)

RKS

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

David Biddulph[_2_]

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

Toppers

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

All times are GMT +1. The time now is 11:57 AM.