# Need Help Creating A Time Sheet In Numbers

I recently began my freelance design career and would like to keep track of my hours in spreadsheet form. I know nothing of spreadsheet applications whether it be Excel or Numbers. I need a basic rundown of how to make my spreadsheet do what I want.

I'd like my sheet to have the following columns:

Date | Start Time | End Time | Total Time

Now, I have seen where the application renders the time in decimal form, which is fine, but would it be possible to show the time in hours and minutes, like 1 hr 43 mins? I would like to know how to get both sorts of results, if possible. If not, I'll settle for decimals.

In any case, if someone could show me step-by-step how to meet this task, I would really, really appreciate it.

Thanks in advance!

## Comments

3,219memberancient console...

In any case, if someone could show me step-by-step how to meet this task, I would really, really appreciate it.

...

In other words, you want someone to design a spreadsheet for your business free of charge.

962memberancient consoleHello, Everyone:

I recently began my freelance design career and would like to keep track of my hours in spreadsheet form. I know nothing of spreadsheet applications whether it be Excel or Numbers. I need a basic rundown of how to make my spreadsheet do what I want.

I'd like my sheet to have the following columns:

Date | Start Time | End Time | Total Time

Now, I have seen where the application renders the time in decimal form, which is fine, but would it be possible to show the time in hours and minutes, like 1 hr 43 mins? I would like to know how to get both sorts of results, if possible. If not, I'll settle for decimals.

In any case, if someone could show me step-by-step how to meet this task, I would really, really appreciate it.

Thanks in advance!

You could of course invest time in learning how to build spreadsheets in Numbers, and reinvent the wheel in the process. But you could also use a specialized application like

Billings(US$ 39,99; integrates with your iPhone for input en route), simply tweak it to your liking and be done with it. And there aredozens more timesheet applicationslike that.You've got a

Mac, you don't need screwdrivers and programming skills to get stuff like this to work. Just install it, set the preferences and your parameters, rates, units, layout, logo, invoicing cycles, etc. etc. And just roll with it.It works.

1member