Concantinated date and time
I have a need to calculate total down time with one cell noting the date of downtime another cell noting the time, and lastly a cell that notes the date and time of when a system came back up. Does anyone know a formula that can concatenate the date and time cells, then use the last cell that marks the uptime to calculate total downtime?
=B1-(A1+A2)
where A1 is downtime start date, A2 is downtime start time and B1 is date and time of system getting back up
Life's a spreadsheet, Excel!
Say thanks, Click *
Can you upload an example spreadsheet showing where these cells are and how they are formatted (Go advanced> manage attachments)?
Typically to combine date and time (if date is in A1 and time in B1) = A1+ B1 and format the cell to show both date and time.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes, that formula worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks