date and time not appearing on excel office 365 blood pressure chart

Can anyone help me to create the formula please? If it is possible, then I would like to link the AVG results to a 2nd sheet to show a chart. but I am not sure this is available via using a formula because each result is a lighter shade of a main colour, the main colour being the one used for the average.Ĭan anyone please help me know if Excel can handle a formula for the way I input the data to create an AVG automatically.

I have a colour code range that reflects the SYSTOLIC result only (that's the high number of the two ref. Occasionally I am too busy and 'miss' a test.

The data collected up to now covers almost 12 months - so there is a lot. Unfortunately I am not very good when it comes to working out a formula for such data. I came across this thread BP Excel Formula and have tried to change what I think should be changed but since I have a 'LEFT', a 'MIDDLE' and a 'RIGHT' number along with the '/' & '-' x 3 for each test, I cannot work out how to alter it to work. plus additional data, I want to keep to this format so that I can easily input and see ALL data I input on a screen without left/right scrolling (not spread out over multiple columns for individual numbers taking up too much width with all the additional data - which I know now would make it so much easier to do, but I do not have time now to reset all the data). The format I use in each column for the digital testing machine's results is S/D-H (85/70-81).īecause this is a standard way of showing these 3 measurements and because with a total of 6 measurements a day. Each time I take 3 tests and then manually AVG. MY SQL Toolkit3-in-1 software toolkit to repair Corrupt Mysql, MariaDB & Analyze logs, and Interconvert Databases.Twice a day I take my BP & heart rate.Also supports recovery from RAIDs & Virtual Drives.

Data Recovery ToolkitSoftware helps to recovers deleted data from Windows, Mac and Linux storage devices.

MS SQL Toolkit5-in-1 software toolkit to repair corrupt SQL database, restore database from corrupt backup, reset database password, analyze SQL logs, & interconvert databases.

It also repairs corrupt PDF files and recovers all objects.

File Repair ToolkitPowerful file repair utility to fix corrupt Word, PowerPoint, and Excel documents created in Microsoft Office.

Outlook ToolkitComprehensive software suite to repair PST files, merge PST files, eliminate duplicate emails, compact PST files, and recover lost or forgotten Outlook passwords.

Exchange Toolkit5-in-1 software toolkit to recover Exchange database, convert EDB to PST, convert OST to PST, restore Exchange backup, and reset Windows Server password.

Date and time not appearing on excel office 365 blood pressure chart