“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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?

Solved by G. Y. in 21 mins

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

Solved by S. L. in 13 mins

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

Solved by F. F. in 28 mins

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.

Solved by S. Y. in 15 mins

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.

Solved by V. Q. in 17 mins

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.

Solved by I. H. in 16 mins

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.

Solved by G. C. in 12 mins

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)

Solved by E. F. in 26 mins

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

Solved by O. A. in 17 mins

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

Solved by G. D. in 11 mins