mins

Hello All, So I have the following data, which is mostly in minutes: 00:01 Mins 00:05 Mins 00:04 Mins 00:03 Mins 00:07 Mins 00:04 Mins 02:32 2 Hours 32 Mins (152 Mins) How do I calculate the average of minutes? (based on the data provided) Currently from Format Cells, Number tab, the data...

I am trying to have a hour displayed as 15 hrs not 015 hrs. Cell I 10 in Text format 10-11-2019 3:48 PM Cell L 10 in Text format 10-12-2019 7:38 AM Formula in M 10 INT(L10-I10)&TEXT(L10-I10,"h"" hrs ""m"" mins """) it returns the answer of 015 hrs 50 mins. I am...

Hi All I've learned quite a lot about working with dates but never worked with times. I have to do some tidal calculations and need to calculate a time 3 hours and 5 mins before high water (I literally have to deduct 3 hours and 5 mins from the high water time which I have in column B) the...

Can somebody help me, our company has this 5 mins grace period before and after the quarter of an hour, and either rounded up or down, example: A1 In - 06:55 (docked at 07:00) B1 Out - 15:36 (docked at 15:45) C1 Total of 8.75 Hours another example: A1 In - 15:21 (docked at 15:30) B1 Out -...

I have a time duration issue once PM runs into AM. I will give an example of a working process (AM to PM) and one that doesn't work (PM to AM) Working Example: A1: Has 11:50 B1: Has 12:00 C1 Formula: =B1-A1 (this will equal 00:10 or 10 mins has gone by) Non-Working: A1: Has 23:50 B1: Has...

I use formula to display 3 hours 7 mins as 3,7. However formula does not work correctly as it should be 3,07 also the are problems with , and . depending on Excel version. I don't need it to be 3,07 or 3,7. I need formula to round it to either 3,5 or 4. So if it is 3,07 then it should be 3,5...

Hi, I am wanting any help please. I need some help to speed up days worth of calculations by making a macro that will automatically provide a helper column with preset formulas on the first column that is empty. It will probably need an input box asking which column and row that I will be...

Hi All Im trying look at a start and end time and trying give 5 mins for every completed hour worked ie if someone worked 02:55 hours then that should return 10 mins as there are only 2 completed full hours but struggling with this formula Also trying to get a multiple or sumifs to total up...

I have a list of times in minutes and want to convert to HR:Min:Secs but none seem to convert correctly. I am using custom format > hr:min:secs, no formula as such. thank you. here is the list in mins >> converts to..... <tbody> 99.7885835 >> 18:55:34 98.4892897 >> 11:44:35 99.0356582...

I have a list of times in minutes and want to convert to HR:Min:Secs but only the 4th in the list converts correctly. I am using custom format > hr:min:secs, no formula as such. thank you. here is the list in mins >> converts to..... <colgroup><col><col></colgroup><tbody> 99.7885835 >>...

HI I am trying to produce a simple spreadsheet whereby I can monitor if staff working alone are overdue to phone in to say they have finished and are safe. All I need is a column for time due to finish and another column that shows time (hrs Mins) elapsed. If that could change colour after...

The below example is an employee who has a previous balance ofleave. If that employee takes time off from work then that time is subtractedfrom his leave. Therefore, used hrs would be deducted from his balance. In the below scenario the employee had 23 days 6 hours and 45 minutes of leave...

Hi, I have a s/sheet for entering time in format [h]:mm Is there a way a data validation that I can ensure users enter the time as hour : mins (using a colon) instead of accidentally using hour . mins ? Many thanks

Hello, I had a question about what a particular time conversion is called if it's called anything at all. Example: The formula I'm using is =((A2*60)+B2)/60 If your children did homework for 4 hours and 30 mins. That can be converted to 4.5 or 4.50 If your children watched TV for 1 hour and...

<tbody> A B C D 1 Reporting Date Date Accepted Difference MET or MISSED? 2 <colgroup width="162"></colgroup> <tbody> 11/07/18 11:50 </tbody> <colgroup width="200"></colgroup> <tbody> 11/07/18 11:51 </tbody> <colgroup width="240"></colgroup> <tbody> 0 days, 0 hrs, 1 mins...

Dear Friends, I have attendance machine providing working hours in decimal for my employees. But issue comes when I want to add the attendance from two separate machines for same employee in excel. For Example: Employee 1 1st Machine - 25.45 (25 hrs 45 mins) 2nd Machine - 1.50 (1 Hr 55 mins)...

HI Team, I have created this form since last 3-4 months and working all well.. I dont understading now, suddenly it is not working. Sheet 3 has activex control command button. On button click, Userform1.Show written. but now from last 10 mins it is showing me, RUN TIME ERROR 13, type...

Hi, I am trying to highlight if an allocated booking time goes over 30 mins - any help to do that would be great! Thanks

i have data that is imported into excell. the data is expressed like this"1h, 24m" which indicates 1 hour 24 minutes how can i convert that into total mins excell doesnt recognise "1h, 24m" as a measure of time is there any vba formula i could use to convert it into total mins? thanks for any help

Here is a sample string from a cell in my spreadsheet: <tbody> PTG X 4 / 60 MINS UNLD I need to grab the 60 out of that string. The word MIN or MINS is always to the right of the number, and the number is always either 2 or 3 digits. Sounds like it should be simple, but...not for me...