Am trying to make a time sheet and having problems with a formula.

Am trying to make a time sheet and having problems with a formula.

Post by Z29kbmlnaH » Tue, 15 Feb 2005 09:15:01


can't figure formula to calculate time accurately. Can anyone help
 
 
 

Am trying to make a time sheet and having problems with a formula.

Post by Ragdye » Tue, 15 Feb 2005 09:15:55

Start time in A1,
End time in B1,
Enter this formula in a cell formatted as "General" or "Number":
=(B1-A1+(B1<A1))*24*AND(A1<>0,B1<>0)


Both A1 and B1 must have times entered for this to work.


This will also work when the times span across midnight.
--


HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================