mins

Hi all I have the following formula I am using to get the difference in mins. For what ever reason the time shows up as 10:23:33:00 from a separate system when loaded into Excel so am using the following formula =TEXT(LEFT(BG6,5)-LEFT(BF6,5),"h:mm") for the most part which works. Now the...

Hi there, I have a userform with 2 textboxes. One is called 'Time and one is called 'mins' I'm trying to get the 'Time' textbox to reflect 'mins' textbox in hours and mins ie: mins = 345 therefore Time = 5:45 I thought I could use something along the lines of: Sub mins_Change() Dim minsVar...

Hi All, I am looking for some help with a formula that will round down if 5 mins past the quarter of hour or round up to the next quarter of the hour if 6 mins past Examples <tbody> 10:01 Result would be 10:00 10:04 Result would be 10:00 10:06 Result would be 10:15 10:15 Result would be...

Hi, I have a start date and time in C1 e.g 01/07/2017 16:25:00 (date is in DD.mm.yyyy format ). In D1 I have an end date and time e.g 01/07/2017 22:15:00. The day is not relevant and is always the same in both cells. I then have the day broken down into half hour chunks eg A2 has 00:00 and B2...

Hello everyone, I just had a question on what the technical name of changing time into decimals is called. For example 1 hour 15 mins is 1.25, 1 hour 30 mins is 1.50, 1 hour 45 mins is 1.75. So on and so forth. 2 hours 32 mins is 2.53. The formula in excel from two cells (one with Hours and...