Take 2. Please ignore my first solution. Here is what you will need:

=HOUR(A1)+(MINUTE(A1)/60)

This will return 2.83 (also the equivalent of 2 hours and 50 minutes).

Hope this helps and sorry for the mixup on Take 1!

"BriSwy" wrote:

Hi Bob.

Assuming that you have 2:50AM entered in cell A1, use this formula:

=(HOUR(A1)*60)+(MINUTE(A1)/60)

Make sure the cell that you are entering the formula in is formatted as
numeric with 2 decimal places.

"vdmbqb" wrote:

I need to enter time in hours and minutes and have the result equal time in
hrs and 100th minutes. ie; 1650-800=8.83 or 1045-800=2.75

any help anyone
--
bob