calculating Time from Decimal in access 2003

Amruta

New member
Local time
Today, 14:43
Joined
Sep 9, 2010
Messages
6
I have a problem calculating Time from decimal values. Could someone please help me.
Description:
(hr:min)I have a textbox on my form which takes input as "start time" e.g. 02:30. There is another textbox that takes in "Minutes" e.g. 90 as input and another textbox that takes in "extended time in minutes" e.g. 60 as input.

Now based on these three i.e. "start time" , " minutes" and "extended time in minutes" i.e. 02:30 + 90 min + 60 min I have to calculate and display "End time" in another text box ...in this case it will be 05:00.

Can someone please tell me how do I calculate this at the click of a button ?
 
Try this sample. Needs tweaking to handle very small times e.g 1 minute. (1/60 gives x.xxxxxxE-02) in the code. Have a look you will see.
 

Attachments

Users who are viewing this thread

Back
Top Bottom