I'm trying to make a time sheet for myself but my time keeps coming up
negative.
in cell a1 i have 9:00 AM (with the cell formated as time h:mm PM) and cell
b1 5:00 PM (with the cell formated as time h:mm PM) and cell c1 formated as
number (with formula (A1-B1)*24 . I'm getting 8 hours but it is coming out
negative.
so my cells look like this
9:00 AM 5:00 PM -8.00
What am i doing wrong? How can i get a positive number?