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
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
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:
- Time formulla use in excell
- Popcorn time download - Download - Movies, series and TV
- How to change time in whatsapp - Guide
- Ocarina of time rom - Download - Action and adventure
- Facebook id verification time - Guide
- Summer time saga - Download - Adult games
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
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
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
