View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default Time period spanning midnight

Stephen,
You might want to consider this:
Column A - Date, Column B -Time, Column C - In, Column D - out, Column F -
Total Hours
In F2 formula is "=IF(B1="","",24*(A2-A1)+24*(B2-B1))
hth
"Stephen White" wrote:


I am working on a time sheet.

Suppose in cell A1 I have a start time and in cell B1 a finish time in a
24hr format (say for example 23:00 or just 2300) and suppose that the
time between them spans midnight. So the two values might be

A1 21:30
B1 3:45

What is the neatest formula to calculate the number of hours between
them?

--
Stephen White )