Get instant live expert help on date and time function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to create a function that will return a date and time that follows business days and business hours
Solved by V. C. in 13 mins
I need to calculate time in hours before surgery from a date and time of surgery and date and time of injury
Solved by K. C. in 18 mins
I need to automate the extraction of only the date (mm/dd/yyyy) from a column that has the date and time (mm/dd/yyyy hh/mm/ss)inputted into it via zapier. Using the LEFT function is not working
Solved by X. H. in 27 mins
I need a fixed time and date formula so everytime I enter information into a cell, the current time and date goes into the next cell without changing the time and date of the previous cells like =NOW does
Solved by Z. E. in 13 mins
I need a formula that will give me an end date and time from a specific start date and time. Example: Start time was 8/8/2018 21:32, I want to find out what the date and time will be in 11 days, 21 hours and 4 minutes.
Solved by M. H. in 16 mins