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