Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
calculate average hours and minutes | Excel Worksheet Functions |