DUration Calculation and Charge finding

[azbi]

Dear Experts

How to calculate duration in excel and find the charge for this duration?
time.xlsx

[FlameRetired]

Try these. In D2

Please Login or Register  to view this content.

Then format h:mm. Then in E2

Please Login or Register  to view this content.

and format for currency.

Row\Col	A	B	C	D	E
1	Date	Time In	Time Out	Duration	Charge
2	02-Nov-15	18:00	22:52	4:52	1,362,666.67

[azbi]

Dear Expert

It's work, and how about finding SUM for column C, if column C has 10 ROW, I tried using SUM, but I think its not correct.
Need your advice

[FlameRetired]

If you mean SUM for columns D and E and D & E use the formulas posted above then you should only have to SUM those columns. Is that what the goals are?

[azbi]

I mead like this time 1.xlsx

[FlameRetired]

It could be done this way.

Row\Col	A	B	C	D	E	F
1		DURATION
2		03:45
3		02:10
4		01:00
5		03:45
6		03:45
7		03:45
8		03:45
9		03:45
10		03:45
11		03:45
12		03:45
13		03:45
14		03:45
15		03:45
16		03:45
17		03:45
18		03:45
19		03:45
20		03:45
21		03:45
22		03:45
23		03:45
24		03:45
25		03:45				In B27 =SUM(B2:B26)
26		03:45				In E27 =B27*24*280000
27	TOTAL	89:25	X 280000	=	25,036,666.67	Format B27 as [h]:mm

I was working on another version before you posted. The file is attached.