Help! Time Value - Removal of Seconds

[ocnmel]

Is there any way to remove the seconds from the TimeValue? It displays as 23:59:00; but I'd like 23:59. Also, is there a way to calculate the value of two ComboBox's?

Please Login or Register  to view this content.

Thanks in advance.

[shg]

Please Login or Register  to view this content.

[ocnmel]

Thanks, Shg! I modified For i = 1 To 1439 and it works perfect.

Would you happen to know how to calculate the value of two or more combobox's? For example, if ComboBox23 is 23:00 and ComboBox24 is 05:00; is there a formula that could calculate the number of hours between the two? And, also on off hours like 05:01 to 17:16?

Thanks in advance.

[shg]

calculate the number of hours between the two?

TimeValue(ComboBox23) - TimeValue(ComboBox24)

[ocnmel]

Hmm! I can't get the above to calculate the number of hours between two. I added it to my code - but perhaps, I'm doing something wrong. I have 4 in times and 4 out times, and I'd like each in/out time to calculate together and then all 4 in/out times be added together as total hours together that calculates with military time and with the minutes...

[shg]

To get decimal hours,

Please Login or Register  to view this content.

[ocnmel]

Shg,

Here's a copy of my worksheet to show you what I am experiencing. Timecard - In-Out.xlsm.

I have linked the ComboBox cells in the properties for cells B11 - B18 and I'd like to calculate all 8 in/out times in B19-H19 and J19-P19. I keep getting a decimal and I'd like to get the total number of hours input and round down (to the nearest quarter hour) if the hours are less than the nearest quarter hour. For example, if the employee has a total of 9 hours, 14 minutes or 9:14 total - the formula would round down to 9:00 hours.

Thanks in advance for your assistance.

[LJMetzger]

See the following test code that rounds down time in 15 minute intervals.

Please Login or Register  to view this content.

Complete implementation at: http://www.excelforum.com/excel-prog...ml#post3962378

Lewis