Get instant live Excel expert help with Time and Date Functions

I need a formula to calculate total pounds divided by total time in hours and minutes to get total pounds per hour example: 46862.4 total pounds with a run time of 4:23 = total pounds per hour can you help please?

Hi i would like a time sheet template Sheet Pairs You enter the Date in Column A it makes the Day in column B You enter the hour you started in Colum C and the hour you finished in Column D (please note that some days we may start at 1500 and finish at 0300 (the next morning) Column E and F use the Same format Column L is Column H - G Column K is the Difference between E and F Column J is Column C and D hours so like the total amount of Hours spent Column N is colum L/J to equal a $ amount

Every trip has a different duration.I need a formula that allows me to know the total half hour trips made. If a trip was an hour long, then it should count has two half hour trips. If a trip was an hour and a half long, then it should count as 3 half hour trips

I created a timesheet calculator for billing, and the way we records our time is in the formula 0.00. If i bill a client 1.45 i need a formula to charge client that amount of time per my hourly rate. For example if i bill the client for 1 hour and 45 minutes, what formula would i use to do that.

I want to return an hourly value in one column based on the amount of something in another. For example if 0-3 = 0 hours, if 3.1-4 = 1 hour, if 4.1-5 = 2 hours, if 5.1-6 = 3 hours etc.

I need a formula that will tell me how many people on a schedule (shown in one column) are here with a certain skill (shown in another column) per half hour interval for a full 24 hour period.

i need help adding up my hours in my billg worksheet. i enter hours both in the "time Entries' and "Bill" sheets. The time is in hours and minutes, so 1.45 is 1 hour and 45 minutes, but in the billing sheet its adding the time up in decimals, so in other words if i enter 1.45 + 1.20, excel will total it as 2.65, and it should be 3.05.

from the following format: 2018/03/10 03:05PM I need the following formulas: Weekday (to be displayed in 1 column) Month (to be displayed in 1 column) Date of day ( to be displayed in 1 column) Hour (to be displayed in 1 column)

Need to convert 12hr time to 24 hour format, but on display the hour, not the minutes'

I need to break down data by hour of day, day of week and month of year