How can I create a reusable function in Excel 2007?
Fresh3 days ago
Mar 15, 20263707 viewsConfidence Score0%
0%
Problem
How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function: (Thanks to Phil Winstanley)
Error Output
=(((HOUR(B3) * 60) * 60) + (MINUTE(B3) * 60) + SECOND(B3)) - (((HOUR(A3) * 60) * 60) + (MINUTE(A3) * 60) + SECOND(A3))
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I create a reusable function in Excel 2007?
Low Risk
This link completely describes how to do it... instructions have been enumerated below: Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Enter the Excel User Defined Function (UDF) in VBA Get out of VBA (Pre…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix