time calculations

[Dillon Mantle]

Hi

How do I add 1:45 to 1:45 to get 3:00

Regards
Dillon Mantle

[Rick Rothstein]

> How do I add 1:45 to 1:45 to get 3:00

You can't... those two times add to 3:30, not 3:00.<g>

As long as the total won't go over 24 hours,

Time1 = "1:45"
Time2 = "1:45"
Msgbox Format(CDbl(CDate(Time1) + CDate(Time2)), "h:mm")

Rick - MVP

[Trousle Undrhil]

"Rick Rothstein" <ri************@NOSPAMcomcast.net> wrote in message
news:UP********************@comcast.com...

How do I add 1:45 to 1:45 to get 3:00
You can't... those two times add to 3:30, not 3:00.<g>

Well, to be truthful, you *can*... :) Just use your code, but add and If
statement to look and see if Time1 and Time2 equals "1:45" then set the
final answer to "3:00". Viola! He didn't ask how to make it correctly add
the times together, just to make those two times come out to 3:00. You
gotta go by command specs and do what they say. Never assume anything. Do
exactly what they say *or* ask first, then code it. :-D
As long as the total won't go over 24 hours,
Time1 = "1:45"
Time2 = "1:45"
if Time1 = "1:45" and Time2 = "1:45" then ' Those sneaky design specs.
MsgBox "3:00" ' Why would they want this value from those?
else
Msgbox Format(CDbl(CDate(Time1) + CDate(Time2)), "h:mm")
end if
Rick - MVP

Ken
un*****@hotmail.nospam.comc

[Greg Siemon]

t = #1:45:00 AM#
t = DateAdd("h", 1, t)
t = DateAdd("n", 45, t)
Answer= 3:30

"Dillon Mantle" <di*****@dasolutions.co.za> wrote in message
news:H_********************@is.co.za...

Hi

How do I add 1:45 to 1:45 to get 3:00

Regards
Dillon Mantle