Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JenMo
 
Posts: n/a
Default time sheet calc by time in and out

Can you calculate total hours by entering the start and finish time? For
example, can you enter 11:30a.m. as the start time and 4:00p.m. as the finish
time and get 4.5 as the calculated answer. If excel can calculate this
figure, then, what format should the cells be in--in order to be able to
enter simply 12 to get 12:00 or 845 to get 8:45. Is any of this possible?
Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"