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?
2007-03-23 01:45:29 · 3 answers · asked by chica_dulce_04 2 in Computers & Internet ➔ Software
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(
press enter n u get ur answer
=P
2007-03-23 01:54:33 · answer #1 · answered by Anonymous · 1⤊ 0⤋
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.
2007-03-23 09:03:09 · answer #2 · answered by Denise D 2 · 0⤊ 0⤋
I wish I could help, that was the one program I had the most problems with.!!!
2007-03-23 08:55:47 · answer #3 · answered by chazzer 5 · 0⤊ 0⤋