timesheet functions

[Darren]

I have setup my own time sheet and initially did most of the calculations in
my head besides the hours for the day sum and then a total of all those using
the sum function.

What I would like to do is to be able to have a start time and end time
column and excel to calculate the time elapsed between those values and round
to quarter hours. How do I do this?

 

[Eduardo]

Hi Darren,
check this web it has all the answers related with time elapsed

http://www.cpearson.com/excel/datetime.htm

If this was helpful please say yes, thanks

 

[Rick Rothstein]

Give this formula a try...

=MROUND(24*(A2-A1),0.25)

Note: This formula requires you to activate the Analysis ToolPak in order
for it to work (Tools/Add-In on the menu bar).