I also believe the OP needs to be entering times as times Excel can interpret
as times, he seems to be using decimals and he either has to convert them
through a formula or use an event macro that replaces the period with a
semicolon
Regards,
Peo Sjoblom
"David McRitchie" wrote:
Format as time with a custom format:
[hh]:mm
the square brackets will keep hours from overflowing into days.
---
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
"Jay" wrote in message ...
I am trying to set up a spreadsheet where I can track, over the course of a
week, how long I work on a specific task every day, in hours and minutes.
I've tried several of the formatting options - General, Number, Time,
Special, Custom but everytime I enter a length of time, for example; 1.45
-for 1 hr and 45 minutes, Excel converts it to a time of the day and not a
length of time.
Is there a way to fomat a row of cells to track lengths of time in hours and
minutes over a week?
Thanks,
Jay