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 to plot a Stress vs Strain Line graph. My data is in two columns and I've spent the past hour trying to find a way for the chart to read my Strain values for the X-axis and my Stress values for the Y-axis, but it only will accept Y-axis values for the table range.
Solved by O. J. in 18 mins
Work out time taken in 24 hour format without using a date and between the hours of 23:00 and 01:00?
Solved by M. U. in 14 mins
trying to create a timesheet calculator for calculating my hours. I only have 20 hrs a week but they round down the number in increments of .25 or 15 minutes. For Example, if one day I only worked for 6 hours and 10 minutes (which is about 6.22 in decimal) but since I hadn't worked the full 6.25 hours it rounds the hour to 6.00 instead. so I'm wondering how to tell it to round down in increments of 0.25. any ideas?
Solved by C. C. in 14 mins
I need to figure out a scheduling conflict. I have 15 softball teams that play at 6pm, 7pm, 8pm, and 9pm every wednesday. I need to figure out the best way to schedule these teams to play each other with the MINIMAL amount of weeks that you have to wait an hour or two between each games. can you help?
Solved by V. A. in 25 mins
Excel Question I would like to figure out a start time of 0700 hours and an end time of 1530 hours, with 1/2 hour lunch deducted. But first I would like to enter the time without having to put in the colon. So what I figured my work is that my start time of 0700 entered into the cell g15 and my end time of 1530 entered into the cell of h15. I used the custom format 00\:00. What formula can be entered into cell I15, where it calculates the total hours worked and minus the half hour lunch if worked more than five hours?
Solved by S. U. in 17 mins
ive separated a cell to 2 individual times: 10:05 - 10:35 using =IF(E3="","",LEFT($E3,SEARCH("-",$E3,1)-1)). So now i have 2 cells that read 10:05 and 10:35 receptively. Id like to add an offset, either + or - a certain amount of time. So i have "10:05 - Offset time (in this case we'll use 1 hour) = 9:05. No problems up to this point. once i put the same equation against the "10:35" time, i get a #value error.
Solved by A. Q. in 29 mins
To get a feel of things based on production and their capabilities. Weekly graph with colored lines for true average to see trends in production, product downside or consistent trends week after week or a stacked chart daily showing where production was spent that day (wires, pads, halo, kits, glue) that will allow us to see trends by the day or date of the week. Total product completed per hour
Solved by I. D. in 30 mins
I need a formula that will help me figure percentages used--ex: we work an 80 hour pay period, when someone uses leave, we need to be able to figure what percentage of that 80 hour period was used as leave
Solved by F. F. in 28 mins
Hi, please can you help me. I have a csv excel file, it has the following information: 4/22/2018 16:00:02,6.26,1.80,874,881,1316 4/22/2018 16:01:02,6.26,1.80,874,881,1317 4/22/2018 16:02:02,6.26,1.80,874,881,1318 4/22/2018 16:03:02,6.27,1.80,874,881,1318 Where the date changes, as well as the time, and there are different values for each month, day, week hour. I need to make it possible to manage this data, by date selection(monthly, weekly, hourly) by means of charts. Can you help?
Solved by A. E. in 15 mins
I need to get some trend data. I have my day of the week all equal to a numerical value (1-7). However, my date/time field is throwing this off. It is currently: 12/10/2017 12:45:00 AM. But I only need hh. I want to show the count of calls that come in per hour on a given day of the week.
Solved by M. W. in 21 mins