Ronnie,

Enter 1 hour and 15 minutes as 1:15:00, not as 1.15. The same for 1:45:00.

Then simply format your cells as time, including the cell where you add the
two together.

But to do some math, such as calculating wages, you will need to convert the
time to hours by multiplying by 24 first.

See http://www.cpearson.com/excel/datetime.htm

HTH,
Bernie
MS Excel MVP


"Ronnie" wrote in message
...
I am currently using Excel on a spread sheet to calculate hours and
minutes.
I need to know how to convert the time entered so that it will calculate
as
time and not normal figures. EG if I enter 1.15 and 1.45 I need it to
total
as 3 hours and not 2.60.

Can you help.