-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
5pm
-
C
Date is in numerical format
I have created the following: ="Data as at 5pm "&TODAY() and it results with the following: Data as at 5pm 43172 Have formatted the cell to date. Doesn't work. Why is the date defaulting to its numerical value? Thanks- coldeskimo
- Thread
- 5pm cell date formatted numerical
- Replies: 1
- Forum: Excel Questions
-
E
excel If date is after or before 5pm the prior working day
Excel dates. I have a date of job and date/ time of job request. If the job was on a Monday, or weekend I need to determine if the job was requested before or after the previous Friday at 5pm. The rules are if a date of job (Job date) was requested (job requested date) after 5pm the prior...- Excel_goon1903
- Thread
- 5pm date job prior requested
- Replies: 1
- Forum: Excel Questions
-
F
Calculating Networkdays Between Two Dates (Factoring in Work Received Outside of Business Hours) for SLA
Hi, I'm having trouble coming up with a formula (or formulas) needed as part of an SLA calculation. A1: Case Received Date and Time (in MM/DD/YYYY hh:mm AM/PM format) B1: Case Completed Date and Time (same format) I need to compare these two dates to identify if the case was completed within...- Funkybot
- Thread
- 5pm business hours network days received sla calculation
- Replies: 2
- Forum: Excel Questions
