calculating time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do we calculate the difference in time in excel? For example, if we
enter 10pm in D2 and 7am in B2 we get some strange number regardless if the
cell is formated as a number or as a time. Does it need to be in 24 hour
time or what are we doing wrong??

Help please
 
tam25 said:
How do we calculate the difference in time in excel? For example, if we
enter 10pm in D2 and 7am in B2 we get some strange number regardless if the
cell is formated as a number or as a time. Does it need to be in 24 hour
time or what are we doing wrong??

Help please
Click to expand...

This is a newsgroup for .NET programmers. I think that you have much
more luck with your question if you post it in a more relevant
newsgroup, like perhaps microsoft.public.excel.
 
Back
Top