Setting up spreadsheet to calculate time
Sorry Mike, I tried it so many ways and got so many results. :)
But your way works!! Thanks so much. Now I have to change the spreadsheet
<sigh but that's ok, lol
"Mike H" wrote:
Meenie,
I have a spreadsheet that someone else made and it just isn't working
Is just about as unhelpful as it gets, what isn't working, what error do you
get?
Getting the difference between 2 properly formatted dates/times is achieved
with subtraction. So
a1=01/01/2007 08:00:00
a2= 02/01/2008 08:10:00
Both formatted with dd/mm/yyyy hh:mm
In A3 enter =A2-A1
format as [hh]:mm and you will get your answer in hours and minutes.
Mike
"Meenie" wrote:
Can you tell me the best way to set up a spreadsheet in order to calculate
time, and the formula to do it for Excel 2003?
I have a start date and time and an end date and time and need to know the
number of hours and minutes between those two times.
I have a spreadsheet that someone else made and it just isn't working. I've
tried several formulas but can't get them to work and I'm pulling my hair
out. I'll go blind if I have to go down this spreadsheet and figure these
times out individually!!
Thanks :)
Meenie
|