timesheet functions

  • Thread starter Thread starter Darren
  • Start date Start date
D

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?
 
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).
 
Back
Top