Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

Timesheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pierce Brosnan - 07 Feb 2007 17:24 GMT
I want to make a timesheet which can calculate my income. Have found
severals, but not what I'm looking for.

I want to be able to input my starting, 11:55, and  ending 12:00. Then I
want the timesheet to calculate that I have been at work for 5 mins. Have
only found for whole hours, not like 11:27 - 15:53.

Any help appreciated!
Sandy Mann - 07 Feb 2007 19:07 GMT
The lack of answers makes me think that I must be misreading your question.

With your start time in B2 amd the end in C2 then surely
=C2-B2 formated as time will give you the answer you want.

If you want to sum all the individual times and they are likely to amount to
more then 24 hours then format the total cell as [h]:mm to prevent the hours
rolling over into days at 24 hours.

To calcualte you income then multiply the hours by 24 and then by the wage
rate.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

>I want to make a timesheet which can calculate my income. Have found
>severals, but not what I'm looking for.
[quoted text clipped - 4 lines]
>
> Any help appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.