Computer problems,Computer help
*AX SOFT>>>Software

Excel Spreadsheet Timesheet Calculations?


I need a cell formula to calculate my only hourly employee at work. She swears up and down that mine is wrong.
She calculated hers by minutes this pay period and came up with 41 hours 5 minutes. Where mine came up with 41.08. I just need to verify I am using a correct formula.

Here is what two days would look like.
I need a sum of both.

10:38 am to 3:05 pm.
10:11 am to 3:01 pm.
At a rate of 8.00 an hour

Thank you to anyone who can help me with this!

My formula is currently:
All time formats are done in Military Times
=(D5-C5)*24 (Daily Where Answer goes in E)
=SUM(E3:E17) (Weekly hours Sum of all E)
=SUM(D21*8) (Amount Paid is result of Sum of all E * Amt)

Note: minutes are divided by 60
= (D5-C5)
(1505 h -1038 h)
3:05pm-10:38am = 4.45 hrs.

(1501 h -1011 h)
3:01pm-1011 am = 4.83 hrs.


4.45+4.83 = 9.28 x 8 = $74.24 for these 2 days

if rounded up:
4.5 + 4.8 = 9.3 x 8 = $74.40 for these 2 days

41.08 is 41 hours and 5 minutes. Minutes are a base of 60, not 100 like a decimal. So 5/60 is .08

Tags
  General - Computers & Internet   Software   Security   Programming & Design   Facebook
Related information
  • How to tile windows on the toolbar at the bottom in MS Windows XP?

    right click the task bar and go to properties. then put a check mark on the button that says group similar taskbar buttons. -C :)

    ...
  • What are the Disadvantages of Microsoft word?

    Those stupid annoying helpers (like the paperclip, the robot etc.)

    ...
  • Where can i find an update file or folder for AVG ?

    www.grisoft.com

    ...
  • Best ports for uTorrent?

    theres no such thing as best ports , but u can try this - tcpoptimizer . i boosted my net speed quite a bit . i was getting ilke 7 kbps max and now i get around 30 minimum

    ...
  • Iso Files and Regional codes?

    generally to make an ISO file of a DVD thats region encoded you will probably need a de-coding program that will bi-pass the copy protection of the DVD. These programs also remove all region encodi...

  • What media players support rar files?

    Well .rar files are not media files... so it will not be opened by any media player... They are zipped or compressed files.. tu unzip u have to use winRAR which can unzip the files and u can th...

  • What Ubuntu flavor is most like windows???

    Kubuntu is more like Windows. It has like windows the same sort of graphical layout. But it is also possible to change the layout in Gnome so that it will look more like Windows. Why don't you...

  • Troubleshooting: How do I see what .dlls rundll32.exe has loaded?

    get the program called FreshDiagnose. More info on your pc than you ever want to know.

    ...
  •  

    Categories--Copyright/IP Policy--Contact Webmaster