Thread: Calculate time
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Mark Ruiz Mark Ruiz is offline
external usenet poster
 
Posts: 6
Default Calculate time

Chip,
It was a formatting issue. Thanks for helping me out.
This will really save me alot of time.

Thnx,

MRuiz
"Chip Pearson" wrote in message
...
Mark,

Specifically what problems are you having when you try to sum the
times?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Mark Ruiz" wrote in message
...
Sorry Chip,
I can't get the sum of the individual times.

Thnx,

MRuiz
"Chip Pearson" wrote in message
...
Mark,

Try something like

=(EndTime - StartTime)+(StartTimeEndTime)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mark Ruiz" wrote in message
...
I have to keep time log for my business travel within the

city.
Does anyone
know of a formula that will calculate the difference of a

start
time and an
end time.

Pleas help!

MRuiz