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

How to use a SanDisk Ultra Backup USB 2.0 Flash Drive I wish to copy from my computer files all my pictures to save and take to use at other computers..Help, Thxs


connect the drive to the computer usb port. locate "my computer" in your start menu, double click it to view all drives. you should see a drive marked "Removable Drive something", double click it to open the usb drive. now leave that window open... Again, go to start menu, open "my Documents" locate and open "my pictures" now use the ctrl key in combination with your mouse to click on the folders or pictures you wish to move (keep the ctrl pressed while you select) they turn blue as you select them. Once selected use Ctrl and the C key at the same time to Copy the selection. now, go back to your removable drive window that is behind your my pictures window, click on the white area in the window and use CTRL in combination with the V key to paste your selection into your USB flash drive, now wait until its all done moving the files.... count an extra 20 seconds after its done before you remove the device to move to another computer. Please use "recommend"+ with your comments if you find this useful . cheers

Aug 24, 2010 | SanDisk Computers & Internet

1 Answer

Why does my nas sound like an airplane taking off from time to time. It's been doing it more lately. A sign of impending trouble?


Sometimes, the fans inside a computer are "heat-controlled", i.e., the warmer that it is inside, the faster (and noiser) that the fan will run.

If there is no fan, then it's the bearings inside the disk-drive that are worn out -- as you state, a total disk-drive "crash" is not far away.

Jun 15, 2010 | Iomega (33033)

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

5 Answers

Nas SCM400 not working


The reason that it goes into recovery mode is because RAID5 is not striping so it has to rebuild the drives to be compatible with RAID5. I used 1TB drives and the 'recovery' took about 16 hours. It would be faster on smaller drives.

This is not a fault in the design, it is how RAID5 works.

Aug 23, 2008 | VisionMan VisionVault 4TB Smart NAS...

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 hdbas8@gmail.com

May 17, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Video problem


unless you repeat them as many times as you need them to appear during the total playlist duration each video will play only once. Thus if your playlist is 30 minutes long and you have 5 minutes worth of videos you ought to set up your videos 6 consecutive times, when the playlist goes back to the beginning the whole cycle starts again.

Dec 13, 2007 | Sony NSP-1 (2724265768)

1 Answer

Two drives fails simoultaneously.


I personally would suspect your Power Supply is dishing out "Dirty Power"
I would sort this problem out first.
This is probably what destroyed the "Other" two in the "Same two Bays" sic

Nov 06, 2007 | HP MSA 1000 (A7450AFS1) Hard Drive Array

2 Answers

Hello!


I saw on ebay they had some Brand New Diskless versions and One Used Working one. I know it is not a fix but a lot cheaper than the $1200-$1500 they used to be.

http://search.ebay.com/search/search.dll?from=R40&_trksid=m37&satitle=p400t&category0=

Nov 05, 2007 | Anthology Solutions Yellow Machine P400...

1 Answer

Freecom 400gb Drive


Have you tried to connect those drive individually and checked if they get detected when stand-alone? If they get detected stand-alone, install the Freedom software happen. Cheers

May 23, 2007 | Freecom (24358) 160 GB Network Hard Drive

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

1,082 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Computers & Internet Experts

Brett Duxbury
Brett Duxbury

Level 3 Expert

2920 Answers

Bill Boyd

Level 3 Expert

33341 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...