conditional formatting time
This is what I have
D1 is Battery Start Run Time, formated custom m/d/yyyy h:mm
D2 is battery run time, formatted as general
D3 is Battery run time left, formated custom [h]:mm:ss, with formula D2/24-D4
D4 is Time on Batteries, fomated custom [h]:mm:ss, with formula =NOW()-D1
"barry houdini" wrote:
Hello Dgwood90
Exactly what values do you have in D2 and D3, are they numbers like 40
and 13 or time values like 40:00 and 13:00? Are these values just
input or derived from formulas, if so which formulas?
|