entering 2.30 instead of 2:30 certainly is wrong.

Time is measured as a fraction of a day. if you
have a time of 8:00 and you want to convert to a decimal
number you would multiply by 24.

More information on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chuck45" <Chuck45.1wy2qa_1129381510.6418@excelforum-nospam.com> wrote in message
news:Chuck45.1wy2qa_1129381510.6418@excelforum-nospam.com...
>
> I had a similar problem as Stacey. I enter data as 60ths of an hour,
> ex. 5.30 and 2.30, but the total comes out as 7.6 and I need it to
> read 8.0 as eight hours worked. Is the format wrong or is there simply
> a calculation I can enter to convert the time?
>
> Thanks in advance.
> chuck
>
>
> --
> Chuck45
> ------------------------------------------------------------------------
> Chuck45's Profile: http://www.excelforum.com/member.php...o&userid=28065
> View this thread: http://www.excelforum.com/showthread...hreadid=476391
>