Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
If A1 contains 8:00 am and B1 contains 4:00 pm...
=(B1-A1)*24 will give you 8 hours. HTH, -- Gary Brown Please rate this posting if it is helpful to you. "JenMo" wrote: 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 |
Display Modes | |
|
|