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 2005

Tip: Looking for answers? Try searching our database.

time calculate

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dave elenor - 16 Feb 2005 13:45 GMT
I have trying to make up a timesheet to calculate times and wage due

1.    06:00 to 20:00 = amount of hrs worked, I would like 14.00 instead of
14:00 hrs

2.    To be able to calculate each day to total hourly week

3.    Calculate to hours by ?7.60 per hour

cheers
JE McGimpsey - 16 Feb 2005 13:52 GMT
XL stores times as fractional days, so to get 14.00, multiply the time
by 24:

A1:     06:00
A2:     20:00
A3:     =(A2-A1)*24         <=== 14.00 when formatted as a number

Note that if your times span midnight, the "later" time (say, 3:00 am =
0.125) will be smaller than the "earlier" time (say, 9:00 = 0.875). You
can use the fact that boolean (TRUE/FALSE) values are coerced to 1/0 in
math operations:

A3:     =(A2-A1+(A2<A1))*24

or use the MOD function:

A3:     =MOD(A2-A1,1)*24

You can get a total using the SUM() function, e.g:

   =SUM(A3:G3)

then the total pay is calculated by multiplying that SUM by your rate.

> I have trying to make up a timesheet to calculate times and wage due
>
[quoted text clipped - 6 lines]
>
> cheers
swatsp0p - 16 Feb 2005 14:28 GMT
Assuming your times are in A1 (start time) and B1 (end time), in C1
enter:

=B1-A1*24    Format C1 as Number (2 decimals)

Pay rate in D1

Gross Pay in E1 is:

=C1*D1   Format E1 as your preferred monetary form.

Good Luck

Signature

swatsp0p

dave elenor - 16 Feb 2005 16:29 GMT
A2 Start Time                                 06:00
B2 Finish Time                                20:00
C2 Total Hours Worked
D2 Per Hour ?7.60
E2 Total Wage for that day

When I have entered calulation into C2     =(B2-A2) result comes back as
14:00 or if I change format to number result is 14.58

>I have trying to make up a timesheet to calculate times and wage due
>
[quoted text clipped - 6 lines]
>
> cheers
Peo Sjoblom - 16 Feb 2005 16:53 GMT
C2 should be 14:00

in E2 use

=C2*24*D2

format as currency

Signature

Regards,

Peo Sjoblom

> A2 Start Time                                 06:00
> B2 Finish Time                                20:00
[quoted text clipped - 15 lines]
> >
> > cheers
 
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.