Hi,
I am trying to make up a time sheet that will allow me to add up the Hours & Mins between a start & finish time, I want it to display the time worked in the following format

Column A - start Time 19:00
Column B - Finish Time 22:03
Column c - Total 3hrs 3mins

I have used the following formula but it requires you to put in the date also, which I would like to remove but not sure how?
=TEXT(TRUNC(A2)+(B2-A2),"dd""/""mm""/""yy"" - ""hh"" Hrs ""mm"" Mins """)

The second part I need is for it to work out how much i would be paid for the 3hrs and 3mins at £6.00 per hour, Again I have a formula below but it works it out as time worked 3.05 but need it to display as 3hrs 3mins
=ROUND(IF((OR(E15="",F15="")),0,IF((F15<E15),((F15-E15)*24)+24,(F15-E15)*24)),2)

I guess what I am trying to ask for, is there one formula that does the job of these two?

Thanks

Justin.