Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Someone who knows functions and equations in EXEL, please help!!!?
I was wondering if someone knows a function or equation that I can use that calculates the difference in time? You know like 6:00am to 3:30pm.. and you want to know how many hours and minutes this is.... It's 9.5 hours. But does anyone know an equation that I can use in EXCEL for this?
3 Answers
- Anonymous1 decade agoFavorite Answer
highlight the cells that u wrote the time,
>right click
>format cells
>choose time (the 6th one)
>beside the Time category click the Type of time u want.
After that, find a cell that u wan ur time to be added or subtracted, n use the SUM formulae.
it goes like =SUM( <cell> +/- <cell> )
press enter n u get ur answer
=P
Source(s): Hey, U just gain something!! =D - 1 decade ago
I just tried it - I am guessing that this is for something like logging hours? Anyway, I used an addition and subtraction equation. The cells containing the actual time were formatted for "time" using AM/PM. The formula cell was formatted "custom" on "h:mm" and then I put formula as =d1-c1+b1-a1. (e1 was the formula cell)
Now this is if you are trying to figure time as in when someone clocks in and out and total time worked. But you still have to change the minutes to decimal. Ex. 3 hours and 45 min = 3.75 hours. I didn't go that far since I don't know what you are using it for. Good Luck.
- chazzerLv 51 decade ago
I wish I could help, that was the one program I had the most problems with.!!!
