Question about Excel (SS8SATAS5128400R)

1 Answer

To turn hours and minutes into decimal

Empleado Start time End Time Total Hrs. HrsToDecimals Cs/Done Total Cs/Hrs Rag 6:55 8:15 1:20 1.33 56 43 Hohn Palmero 9:15 10:10 0:55 0.92 45 50 Ber

0:00
21 #DIV/0! Ber 6:50 8:40 1:50 1.83 72 40 Steven

0:00
46 #DIV/0!
Dates in column TotaHrs. that has time format, I need they become decimal dates, I do it manually because I don't know if Excel has a function to do this


Thanks for you answer if it exists

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers

Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Posted on May 20, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Simple pro rata formula for time and money. ie. 1hour = $35 so how long for $23? cant get my head around 1 hour being 60 mins


I suggest you adopt the decimal clock. 0.1 hour (6 minutes) will be $3.50 or 0.05 hour (3 minutes) will be $1.75 and once you have a policy of using those decimal units, time and therefore the cash amounts will be rounded up to the nearest 0.05 or 0.1 hour.

To answer your question use a calculator and divide the required amount by $35 to obtain a decimal fraction of an hour, in this case $23 will buy 0.657 hour which for practical purposes is an unwieldy figure and for most purposes be rounded up to 0.7 hour (42 minutes).

If greater accuracy is required 0.657 x 60 (minutes) = 39.06.

Lots of workshop environments use the decimal clock and vehicle standard repair times and the resulting charges are decimal, the majority to 0.1 but some to 0.05.

I hope this is helpful...

Jan 21, 2017 | Pro Computers & Internet

1 Answer

How to get grand total of the month on sharp cash register ER-2385


I can't believe we still have a book for this one - the ER2385 began production in 1987!
Most business owners take their totals daily. You probably have, too, by turning the key to Z1 and touching
. CA/AT (I hope you can the decimal point in front of the CA/AT. It's essential.)
To take monthly totals, do exactly the same thing, but in the X2/Z2 position.
Note that these totals are monthly only because you print them monthly. If you do it every Saturday night, you'll get weekly totals. The register prints totals that have accumulated since the last time you took a Z2 reading. It's up to you to make them monthly by taking them monthly.
So, on January 31 take your usual nightly total, then the Z2 total. Taking the daily one first ensures that today is included in the month.
Skipping the decimal point before the CA/AT will give you an X2 total. The same numbers will be printed, but they won't be cleared back to zero. That's fine if you want to see your totals so far, without messing them up, but if you forget it at the end of January, then February's totals will include both months. The same rule applies to daily totals. Use the decimal point if you want the numbers cleared.
While the CA/AT key gives the familiar department totals, other readings are available.
PLU gives your PLU totals, if you use them. (X1 and Z1 only)
#/TM gives totals for each hour of the day (X1 and Z1 only)
SBTL gives a total for each day of the month (X2/Z2 only)

Dec 30, 2012 | Computers & Internet

2 Answers

How many hours is part time before paying tax


When your total wages exceed the minimum Earnings, you will have to pay. Typically, you pay each paycheck and then file tax returns for excess contributions for a Refund.

Browser search 2012 Federal Tax Withholding info. I want to say its like $600 total annual but I easily can be wrong. Just know that the Paperboy pays income taxes.

Most of the time, employers deduct and your special status, (student, dependent,etc.) is up to you at end of year.

Don't forget FICA, Medicare type tax, State Tax, etc.

Please rate my info.

Nov 13, 2012 | Cars & Trucks

1 Answer

How to set time on timex 1440 sports watch


Welcome to FixYa!
Here's your request.
TIME AND DATE 1. Press and hold MODE until HOURS digits flash (you'll be in Alarm Mode) Press MODE again to enter TIME mode, SECONDS digits will flash. 2. Press ADJUST to set SECONDS to zero. 3. Press START/STOP to select MINUTES. 4. Press ADJUST to change. 5. Repeat to set HOURS, MONTH, DAYS, and DAY of WEEK. Go through 12 hours to set AM or PM. 6. Press MODE when done. 7. To display DATE from Time display , press START/STOP. 8. With DATE displayed press and hold START/STOP, then press ADJUST to change display between DATE-MONTH and MONTH-DATE. 9. With TIME displayed, press and hold ADJUST, then press MODE to switch between 12-and 24-hour format.
ALARM AND HOURLY CHIME 1. Press and hold MODE until HOURS digits, DAY, and A or P (for AM or PM) flash. 2. Press ADJUST to change HOURS digits. Go through 12 hours for AM or PM. 3. Press START/STOP to select MINUTES. 4. Press ADJUST to change.. Press MODE when done. 5. Press and hold ADJUST, then press START/STOP to turn chime on/off. Press START/STOP again to turn alarm on /off. Release START/STOP when done.
CHRONOGRAPH 1. Chronograph will count up to 24 hours. Lap times are not stored. After 40 minutes chrono display changes from seconds to minutes. 2. With time displayed, press MODE to select Chrono Mode. 3. Press START/STOP to start. 4. Press ADJUST to view lap time. Press again to sesume lap timing. 5. Press START/STOP to stop timing . Press ADJUST to reset chrono to zero. 6. Repeat for successive laps.
Thank you for using FixYa! Have a great day.
Jas247

May 06, 2011 | Timex Watches

1 Answer

I purchased a Sears Counter Craft Crock Watcher crock pot at an Estate Sale, but there is no instruction booklet. It has low, high, and auto shift on the dial. Can you help provide some instructions for...


From a couple of different slow cooker manuals - most I looked at are the same:

When in the AUTO setting, the slow cooker will begin cooking on HIGH and then will shift to LOW after approximately 2 hours of cooking time. AUTO setting does not turn off the unit. Other favorite recipes may be adapted to the slow cooker. All times listed in the following chart are approximate and should serve only as cooking guidelines.

Regular Cooking Slow Cooker Cooking Times

1 (Low) 2 (High) AUTO

30 minutes 6-8 hrs. 3-4 hrs. 5-7 hrs.

35-60 minutes 8-10 hrs. 5-6 hrs. 6-8 hrs.
1-3 hours 10-12 hrs. 7-8 hrs. 8-10 hrs.

Sep 16, 2010 | Vacuums

1 Answer

How do I change the date on a Sharp EL-1801V calculator?


Hello,
Below is the step by step directions on how to update the date/time/tax rate. To set the date, time or tax rate, set the "Grand Total/Rate Setting Mode Selector (GT . RATE SET) to "RATE SET" position.
For Date:
1) Enter in the order of month, day and year, with the decimal point in between each set of numbers. Month 1-12, Day 1-31, Year: 2000 - 2999 (4-digits) or 00-99 (2-digits).
Example 04.10.2010
2) After the year, press the button with the clock/calendar symbol to complete the entry. When this button is pressed, the number entered is evaluated and displayed as "date" if the value is within the following range; "Error" is displayed otherwise, and the previously set date is restored.
For Time:
1) Enter in the order of hour, minutes with a decimal in between the hour and minutes, then press the button with the clock/calendar symbol to complete the entry. (No seconds value is entered) When this button is pressed, the number entered is evaluated and displayed as "time" if the value is within the following range; "Error" is displayed otherwise, and the previously set time is restored. Hours must be represented with 0-23 (24-hour system for the hour entry), Minute: 0-59.

FYI, This calculator uses CR-2032 lithium battery.

Enjoy!

Apr 10, 2010 | Sharp EL-2630P Calculator

1 Answer

REQUIRE EXCEL TIMESHEET Thursday to Wednesday. With DAY, date, start and end times with 1, 30 MIN meal break, total hours for the day (not to exceed 7), any time over 7 THEN GOES TO TIME IN LEIU COLLU


Here are already prepared template time sheets of which your description fits several.

http://office.microsoft.com/en-gb/templates/CT101172771033.aspx?av=ZXL000

May 30, 2009 | Microsoft Excel for PC

2 Answers

Need instructions for Timex 1440 Sport watch


TIME AND DATE
1. Press and hold MODE until HOURS digits flash (you'll be in Alarm Mode) Press MODE again to enter TIME mode, SECONDS digits will flash.
2. Press ADJUST to set SECONDS to zero.
3. Press START/STOP to select MINUTES.
4. Press ADJUST to change.
5. Repeat to set HOURS, MONTH, DAYS, and DAY of WEEK. Go through 12 hours to set AM or PM.
6. Press MODE when done.
7. To display DATE from Time display , press START/STOP.
8. With DATE displayed press and hold START/STOP, then press ADJUST to change display between DATE-MONTH and MONTH-DATE.
9. With TIME displayed, press and hold ADJUST, then press MODE to switch between 12-and 24-hour format.

ALARM AND HOURLY CHIME
1. Press and hold MODE until HOURS digits, DAY, and A or P (for AM or PM) flash.
2. Press ADJUST to change HOURS digits. Go through 12 hours for AM or PM.
3. Press START/STOP to select MINUTES.
4. Press ADJUST to change.. Press MODE when done.
5. Press and hold ADJUST, then press START/STOP to turn chime on/off. Press START/STOP again to turn alarm on /off. Release START/STOP when done.

CHRONOGRAPH
1. Chronograph will count up to 24 hours. Lap times are not stored. After 40 minutes chrono display changes from seconds to minutes.
2. With time displayed, press MODE to select Chrono Mode.
3. Press START/STOP to start.
4. Press ADJUST to view lap time. Press again to sesume lap timing.
5. Press START/STOP to stop timing . Press ADJUST to reset chrono to zero.
6. Repeat for successive laps.

Nov 22, 2008 | Timex 1440 Nylon watch

Not finding what you are looking for?
Computers & Internet Logo

1,084 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

3285 Answers

Bill Boyd

Level 3 Expert

37699 Answers

Lala

Level 2 Expert

34 Answers

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

Answer questions

Manuals & User Guides

Loading...