Addting time ...

[Karnik]

Hello Experts,
I am adding time except total shows 2:75 hours it should be 2:45 see below

A...................B..............C...............D.
Start time.......End time.....Break.........Total Hrs
15:00.............18:00.........00:15.........2:75

Formula under column D is =((B2-A2)-(C2))*24

Any solution/guidance?
Thanks
Karnik

[alansidman]

I entered data as shown and used this formula (B2-A2)-C2 and the result was 2:45

[Karnik]

Thanks Allen,
As suggested I removed 24 and changed format to "time"
Cheers
Karnik