Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
9 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Display current day and time in google sheet
Posted on 2014-11-12
Sheet: https://docs.google.com/spreadsheets/d/1hpp_HYEOVPzBnfCRZwQfpsYuAxkK8e31OVeFzAz4tsg/edit#gid=323269223
The current formula on row 12 is this =IF(E12="","",IF(E12="+","
However, it appears wrong because it only produces an AM value instead of both.
I need to base the current day and time in cell F12 and the offset in the adjacent E12 cell using a formula. Using the fill handle, I need the rest of the cells to fill with the current time based on their offsets.
Assistance in correcting this is greatly appreciated.
The current formula on row 12 is this =IF(E12="","",IF(E12="+","
However, it appears wrong because it only produces an AM value instead of both.
I need to base the current day and time in cell F12 and the offset in the adjacent E12 cell using a formula. Using the fill handle, I need the rest of the cells to fill with the current time based on their offsets.
Assistance in correcting this is greatly appreciated.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
-
2
5 Comments
Thank you both very much. I chose the first one only because it looked more understandable to me than the second one. However, there may have been a good reason to choose the second one so I would like to open up for discussion. Thanks very much for the contribution.
1. =IF(ISBLANK(D4),"",TEXT(NO
2. =IF(E12="","",TEXT(NOW()+5
1. =IF(ISBLANK(D4),"",TEXT(NO
2. =IF(E12="","",TEXT(NOW()+5
New unrelated question here >> http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_28561807.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Suggested Courses
Course of the Month9 days, 11 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.