Get instant live Excel expert help with Time and Date Functions

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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