Thread
:
Enter Standard Time for H:MM Formula
View Single Post
#
21
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 6,953
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.
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy