Need a project.

B

bach

Hi guys and girls,

Want to learn excel, but find the best way for myself to learn is to
develp an actual app for someone to use with all bells and etc on.
Does anyone have an idears.

Bach.
 
B

Bob Phillips

A good one that often crops in these newsgroups is a timesheet.

It has many elements
- data - names and times
- multiple formulae, start end times, overtime, differing rates, pay rate
- presentation - using a good layout, appropriate use of colour
- maybe data validation to ensutre valid data
- maybe conditional formatting to highlight special points.

Should get you started.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Do a google search on Excel timesheets.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
L

LurfysMa

Hi guys and girls,

Want to learn excel, but find the best way for myself to learn is to
develp an actual app for someone to use with all bells and etc on.
Does anyone have an idears.

Bach.

I need a business plan done. Are you a CPA? ;-)
 
B

bach

I am a total beginner, I was looking for something to get into.

It seems that something has falling into my lap that looks quit
complex a lot of things can be done for it.

So i shal be posting loads.

First question

This project uses time can you enter time as 01:30 hours rather tha
1.50 which seems to be done alot
 
B

Bob Phillips

Yes you can enter time as 1:30. When entered as time, the value held is a
fraction of 1 day, that is 0.0625. If you want to see 1.5, multiply by 24.

You can add time as easily as adding numbers.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top