View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Enter Standard Time for H:MM Formula

Just for completeness:
And I replied. You responded that what I sent appeared satisfactory.

--
Regards,
Tom Ogilvy

"Benz" wrote:

I sent you an e-mail from benzNbent@hotmail

"Tom Ogilvy" wrote:

Send me a sample worksheet to (with a valid return address)


or give me your email and I will send you something with all of them working.
--
Regards,
Tom Ogilvy


"Benz" wrote:

Am I doing something wrong? I've tried everything everyone of you have so
nicely suggested and nothing has worked.

"Benz" wrote:

To compute time spent on hourly projects, I need to know formula that will
allow me to enter standard time and have it find the difference

ie/
(Start)A1: 4:00
(End)A2: 6:48
(Total)A3: 2.8

It sounds so easy just subtract the time and divide the Minutes by 60 but I
just cant get it. Plz help! Thank You.