Question about Computers & Internet

1 Answer

Excel calculations I currently have a work hours time sheet which is in a time format, when entering the hours everything apears correclty. However, for my totals for each day unless the time is rounded to the nearest quarter the calculation show incorrectly eg. 9.86 which i read as 9 hours and 86 minutes hour 86 minutes is 1 hour and 26 minutes. how do i make this work???

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 133 Answers

Just enter using this style


TIME IN TIME OUT HOURS 10:00 16:50 6:50 10:22 17:34 7:12 9:00 10:00 1:00
the formula in HOURS is Time Out - Time In

Posted on Mar 20, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Export tally data to excel


tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 Matrix Printer

1 Answer

Wages bill reg


Format both cells with the time format "h:mm AM/PM".
Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"

Apr 16, 2009 | Microsoft Excel for PC

1 Answer

Query for Excel


i dont think it is possible

Nov 01, 2008 | Microsoft Excel for PC

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer

Excel question


You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Attendance sheet in Excel


Hi KDina,

If you need me to work on this project for you please contact me at [email protected]

May 17, 2008 | Excel (SS8SATAS5128400R)

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

4 Answers

How can i export tally data to excel format?


Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. excelexport.jpgIf you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

excelexport2.jpgThe special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

0 Answers

AVG TeCH SuPPoRT PHoNE {{18OO/-/8O31O69}} NuMbEr jkkxz This AVG USA phone number is ranked #2 out of 2 because 7,728 AVG USA customers tried our tools and information and gave us feedback a fter they called. The reason customers call # I:8OO:,:8O31069 is to reach the AVG USA Tech Support department for problems like Where to buy, Complaint, Tech support, Repairs, Returns. As far as we can tell, AVG USA has call center locations in New Mexico and you can call during their open hours Mon-Fri 9am-8pm EST. AVG USA has 2 phone numbers and 4 different ways to get customer help. We've compiled information about I8OO8O31O69 and ways to call or contact AVG USA with help from customers like yourself. Please help us continue to grow and improve this information and these tools by sharing with people you know who might find it useful. Calling AVG USA Calling AVG USA at this number should be pretty straightforward. Also important is what you do once you call, or what your other phone number options are. First of all, we strongly recommend using our free call-you-back tool. Essentially, we navigate their phone menu for you, wait on hold, and then call you when a representative from AVG USA Tech Support can talk. Generally, it saves you at least 27% of your wait time. So it's faster and you don't need to listen to bad hold music. Once on the phone with AVG USA's Tech Support department, you may need to provide them with information that identifies you as a customer, like your full name or name on the account, email address, phone number, or an account number. It's usually worthwhile to gather this information before you call. Click here if you want to compare AVG USA's phone numbers against each other. Contacting AVG USA in General While I8OO8O31O69 is AVG USA's #2 most popular phone number, it's not the only way to get a hold of their customer care team. You already know from reading above that I8OO8O31O69 is their best customer phone number overall, and we have put together a comparison of their 4 total ways to contact support for you to look at as well. One thing to keep in mind as you try to reach AVG USA help by calling them, is that other customers give their customer support at this number a 84% score for their communication skills and a 94% score for the overall help they received. That could be indicative of their abilities to help you resolve your problem overall, regardless of whether or not you call this number. Click here to see a comparison of all the phone numbers, social media and other avenues to contact AVG USA.

Oct 16, 2019 | AVG Computers & Internet

Computers & Internet Logo

Related Topics:

103 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...