Has anyone created an Excel template for tracking times?
Parents
Former Member
I would love to have one. I can't figure out how to get Excel not to convert time times into "time" (i.e. time of day). Actually if I just knew how to do that, then I'd be set.
Go to (i.e., highlight) the Cells you want to format. Click on Format.........Cells..........
Choose "Custom" then find one that looks like mm:ss.0
In the input type box add another zero to it
mm:ss.00
and it works. I'm doing this with Excel 2000 (your version might be a bit different but these are the steps.)
Good Luck
Reply
Former Member
I would love to have one. I can't figure out how to get Excel not to convert time times into "time" (i.e. time of day). Actually if I just knew how to do that, then I'd be set.
Go to (i.e., highlight) the Cells you want to format. Click on Format.........Cells..........
Choose "Custom" then find one that looks like mm:ss.0
In the input type box add another zero to it
mm:ss.00
and it works. I'm doing this with Excel 2000 (your version might be a bit different but these are the steps.)
Good Luck
