hours and min

  1. B

    Difference in time in two cells

    Hello all. I need help finding the difference between two times entered in C19 (start time, formatted to time) and F19 (end time, formatted to time). I need to split the results in two different cells, AI19 (hours) and AL19 (minutes). There red will be a lot times when the users time is...
  2. E

    Calculating hours/minutes between time ranges

    Hello all, I'm in dire need of finding a better solution to this problem: I am in need of caclulating the time between multiple time ranges. Time Range A is a recurring schedule for the month of November, that allocates specific time slots to users, who are then allowed to login during these...
  3. E

    Calculating the hours/minutes time ranges do not overlap

    Hello all, Hopefully I can explain this clearly... I am currently trying to calculate the hours/minutes from Time Range A (which is a recurring schedule of APPROVED time ranges) that do NOT overlap with Time Range B (which is a larger data set of different login periods). Basically, users will...
  4. D

    Hours and Minutes: Decimal to Time

    Hi, please forgive me if this question has been asked but for the life of me I cannot figure out how to do this. I have a list of work hours that our timekeeping system posts in decimals and fractions of hours. For example, if someone worked 5 hours and 45 minutes, the system writes it as 5.75...
  5. J

    Converting duration in NUMBER format to duration in TIME format in Excel.

    Dear all, I have the duration data for more than 40000 rows in the number format. I need a method to convert the same into time format in excel. BY saying number format i mean 1 Hours & 45 minutes has been given as 1.45. I would like to have the same value 1.45 in the TIME format in excel so...
  6. K

    Extract date and time from pasted cell data to use in formulas

    I copy and paste the following data from the UBER website. Data before copy and paste: TIME DURATION MILEAGE FARE October 31, 2014 12:50PM PDT 37:05 8.76 $19.22 October 29, 2014 4:20PM PDT 12:18...
  7. L

    Data Validation for Time (h:mm)

    I am trying to limit my users to entering hours and minutes as h:mm only. The total hours and minutes can be greater than a 24-hour day, however, as in total vacation for a year. Any ideas? I'm drawing a blank. Thanks
  8. S

    Add year,month,day,hours and min

    Hi Friends, I need an excel formula to Add year,month,day,hours and min which are placed in a each column. The resultant date format (dd/mm/yyyy HH:MM) should be in a single cell. Pl. refer the snap for quick details and help in. Thanks Sat.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top