o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

addition of hours and minutes in access -

Hi,

There is a part in my program where I add hours and minutes after each session of tutoring. So for example, 2 hours and 30 minutes would be added to the time that's already in the database. Now my question is, if a person adds 30 minutes to the following time, and the running total of hours and minutes are 5 hours and 45 minutes...how do I make it so that it adds an hour to the hours section, and makes the time to 15 minutes??
So how do I make it automatically add to hours when the minutes exceeds 60?

This is done in MS ACCESS

 

addition of hours and minutes in access -
Hi, There is a part in my program where I add hours and minutes after each session of tutoring. So for example, 2 hours and 30 minutes would be added to the time that's already in the database. Now my question is, if a person adds 30 minutes to the following time, and the running

format total in minutes into hours and minutes -
i have to count minutes and convert them to hours and minutes, i.e. 0800 0830 0530 ------ 2160 2160 must become 22 hours, how do i format this?

[2008] Converting minutes to hours + minutes -
I have a value in my SQL database that is an integer and represents the total amount of time (in minutes) spent on a job. I would like to have a label on my form that pulls that value from the database and converts it into an hour + minute format. For example: 140 in the database woul

[2005] Converting numbers to time -
I'm trying to build a simple program that will take numbers in hours, minutes, and seconds. That looks like this. I was wondering if anyone had any suggestions on an easier way to do this. Here is my code so far. Code: Private Sub displayButton_Click(ByVal sender As Object,

Datediff question(Resolved) -
I have a TimeIN datetime and TimeOut Datetime field in my sql Table. I need to find the Total hours and minutes between there two times. Datediff giving me only days or hours or minutes. Not hours and minutes SELECT datediff(n,'12/2/2005 12:20:00 AM','12/2/2005 1:03:00 AM')

SATA Raid (AKA the devil) -
I am building my own computer and stuff and want to raid 0 my drives. My motherboard is a intel d945gnt and supports sata raids. I created my raid volume and downloaded the newest F6 floppy driver disk thing. Upon the windows install, i press F6 to configure raid driver. After it loads

The Campaign for Real Days -
I am aggrieved at the amount of time currently allocated to the programmer's day. 24 hours is insufficient. A third of it is spent sleeping if you are lucky, another third at work, leaving 8 hours.. 2 hours of chores and stuff, 20 minutes to go and buy beer, then somehow we are

[resolved] right data type to store hours and minutes -
Hello friends what is the right datatype to store the hours and minutes part in the database? i found some info which says we have to convert the duration(hrs and min) into minutes and then store is it the right approach? Regards Sara

[2005] TimeSpan question -
Guys, say the value of total minutes is 209. I used : Code: new timespan(0,209,0).TotalHours I get the result as 3.48 hours. But when I think of it 180 minutes is 3 hours and there is a remaining of 29 minutes from 209. The answer should be 3.29 hours. 209 - 180 =

Minutes into Hour -
Is there any predefined function which I can use to convert minutes into hours? 75 minutes should be 01:15 20 minutes should be 00:20

GetTickCount help [resolved] -
i use GetTickCount to get the ms of the comp uptime, and i can set the seconds, minutes, hours, and days with no problems *except* that the end result is 3 days, 81 hours, 4860 minutes and 291600 seconds instead of 3 days, 8 hours, 42 minutes, and 5 seconds any help please?

C++ question -
yes yes i know it's a vb site but know there are some of you out there that know C++ too, so here i go..... I guess this is like using select case in VB. switch (selection) { case 1: cout << " How many hours would you like to convert?: "; cin >> Ho

Convert minuites to days,hours.. -
I have calculated the difference in minutes between two dates. I now need to convert these minutes into days, hours and minutes. What is the easiest and most accurate way to do this? Thanks.

Minutes to Days, Hours & Mins -
Given the value of 1530, being the minutes total of 1 Day, 1 Hour & 30 Minutes. Has anyone got any ideas on how to calculate the given value back to Days, Hours & Mins? Regards,

Hours out of minutes -
Can someone just make a code real quick where say you have 450 minutes, and the code will make like hour$ how many hours that is and min$ how many minutes it is. So that both are seperate integer strings.. thanks

save time to a database -
i am doing a timekeeping program...now i dont know how i can round off seconds into minutes then minutes into hours...also, i obviously would be working with time-in and time-out of employees and so i need to compute the difference so that i can find out the total number of hours worke

vba excel problem -
I am working on a previously designed spreadsheet that when designed had a slight flaw in logic. Basically when it was designed it was made to keep track of time, however the time was entered as 3.15 for 3 hours and 15 minutes and 4.55 for 4 hours and 55 minutes. This would work fine

select time (hours,minutes,second) in updown arrow -
how can i select time (hours,minutes,second) in updown arrow buttons in VB.NET. as we have current time displayed in date and time properties in our system. in date and time properties, while we press updown arrown, that will change only hour first, and if we select the minutes a

sum the hours in crystal -
I have a report which displays hours (eg 1:33 ) worked by each employee on a job grouped by date. I need to display the total hours on each day. How can I sum the hours in crystal using a formula or some other way possible. I need the total in hours and minutes . thx for your help

Hour & Minute countdown -
i want to countdown in hours and minutes till i get a msgbox, the user is entering the number of hours/minutes. Also some users may choose to pick 0 hours and just want a minute countdown. Rgrds WilliamRobinson

Convert .TickCount to Hours/Minutes/seconds -
Working with System.Environment.TickCount, it returns an integer containing the total amount of milliseconds that the system has been up since the last restart. What is an easy way of formatting this or converting this to Hours/Minutes/Seconds? I realize you can just start dividing by

Convert Seconds to Days Hour Minutes Seconds Crystal -
This code was orginally designed to convert total seconds to Hours:Minutes:Seconds and display a total. However my fields get so big I need to add a day conversion and I might be the worst person at math ever. I have added the Days portion of this and it shows the days but I can't

Timer and slider -
Hello. I'm making my own wallpaper changer, which runs in the background and I'd like to use a Slider to select the interval for changing the wallpaper. I have used Timers before, but the interval times were never longer than 1 minute. Now I need to have intervals of 15 minutes,

continuous loop the coding -
hi all, i hv a countdown timer coding here. how to edit it so that when the timer reach 0:00:00, it will return back to countdown again? (i.e if i set countdown for 10 minutes, after reach 0:00:00, call a function, then countdown for another 10minutes, and keep repeat and repeat) C

How many hours in a day -
I know I have seen that it is not exactly 24 hours. Something like 23 hours 59 minutes 56 seconds. Anyone know? I have searched my butt off and I can't find it!

Convert minutes to hours -
Hi all, How will I get the hour and minutes in 70 minutes using VB code?

Convert minutes to Hour and minutes -
I want to convert minutes to hours and minutes (alot of minutes) anyone??

Totalling Hours -
Hello, I have a report that calculates the salaries of employees. In addition to that it calculates overtime hours. Now, I've been trying to work on a formula that would calculate the number of overtime hours. Which is supposed to be if an employee stayed for more than 8 hours at work

Minutes to Hour & minutes -
Hi How can I convert the total minutes into hour minutes. ex: Total minutes : 209 I want it should display : 3 hours 29 minutes thanks asm

Build a Schedule -
Hi How can I to build a Schedule with Hours and minutes , when The Columns are Medicals and Rows are Hours and Minutes Are some control that to do It ? +----------+--------+---------+ : kasparov : karpov : Fischer : +----------+--------+---------+

How do you convert seconds to h/n/s format -
Hi, there. I'm using VB.NET and have a number that represents total seconds. I would like to be able to translate the total seconds into a more useful format such as hours/minutes/seconds or even days/hours/minutes/seconds. e.g. If there are 5657 total seconds, this translates

2 problems with these function -
i'm using visual basic 6 and i build a function for convert the milliseconds to these format: HH:MM:SS... but i found 2 problems: -the conversion isn't correct; - and i don't know use the format function for put the 0(zeros): 00:00:00. heres the function: Code: public func

Excel question: calculate how long it takes till XX time -
so lets say its 8:00 PM, I have a cell #1 that has 11:30 PM.... I want cell #2 to tell me the difference between now and cell #1... So if I looked at it now, it would tell me 3 hours and 30 minutes... if I looked at it 30 minutes from now it would tell me 3 hours... 60m from now and

Converting a number into hours, minutes, seconds -
How would you convert a number like 100043 (it's in seconds) into hours, minutes and seconds? I'm stuck! I've tried using Timespan and DateTime but can't get it to work properly. It would need to end up showing something like this 27h:46m:04s. Can anyone help?

XBL New dashboard!!! -
I started this thread while my XBox was busy downloading the upgrade, in the hope that it would be finished by the time I'd written this first paragraph. I'll fill you in on the details, I currently have 1% downloaded so far with 47 minutes remaining. No wait, now it's 33 minutes

Determining Time passed... -
I have an application that needs to wait a certain amount of time... 10 minutes to 5 hours for different events to happen. I would like to have a timer that would tell me the hours and minutes and seconds until this event happens. This is very trivial unless this event happens ov

Calculating Days/hours/minutes/seconds between 2 dates -
Hi guys, I have 2 dates+times and want to find out how many days, hours, minutes and seconds there are between the 2. How can i do this as im getting some odd values (the year 1899) for example. Thanks for any help

Convert Hrs into minutes -
Hi everybody.. Here i was getting problem with hrs and minutes.. Actually what i want was , to convert 2.5 hrs to "2 hrs 30 minutes".. that is it should have to give user inputed hours(like 2.5hrs in abv case) it should have to give a msg in minutes like 2hrs 30mins

Rounding Time unit to 15 minutes -
I am currently writing a program that records the number of hours worked on projects to the nearest 15 minutes. i.e 2:25 2:50 2:75 3:00 The most common error that users are making is inputting 2hrs 15mins as 2:15 rather than the required 2:25 Has anyone got a routine that

Help in solve this question... -
Can anyone please help me solve this Question from Quantitaive Section in GRE Ques : A lion can eat a sheep in 2 hrs, wolf in 3 hrs, and a dog in 6 hours. In what time would they eat a sheep together? Answer options : a. 60 mins b. 75 minutes c. 52 minutes d. 55 minutes Th