Time formulla use in excell

Closed
satishbavarva Posts 1 Registration date Tuesday September 3, 2013 Status Member Last seen September 3, 2013 - Sep 3, 2013 at 05:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 3, 2013 at 07:02 AM
i use excell 2007 i want to use time formula in excel example for
timeshit i enterd my company 7:00 am and i exit my company 23:00pm its autmatic calculation time my present im company but not confom enter and exit time in am ya pa plz tell me formula
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 3, 2013 at 07:02 AM
not clear what you want

enter a1
7:00 (am not necessary)
enter in B1
23:00(pm should not be there)

in c1 formula
=B1-A1

format C1 as hh:mm
0