Jay,

I do this. I wish I could just upload my document right here for you to use.
I just use number format with two decimals. Then I round min. to the nearest
1/4...

1.25
1.5
1.75

The next step is to use miltary time instead of standard time.

My worksheet subtracts my end time from my start time and tallies up the
entire week - no problem.

"Jay" wrote:

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