Hello,

I'm not very good with excel and I've been searching forums for help and there are some very close answers but nothing close enough. I'm trying to create a timesheet that takes into account multiple in and out times and uses decimals to denote time so 5am and 5pm both show as 5.00. The total hours should then be calculated out in quarter hours. I've provided an example below, in this instance the correct Total Hours for Friday would be 11.25, I just need a function that will help me get that. Any assistance would be great.

<colgroup><col><col></colgroup><tbody>

</tbody>

I'm not very good with excel and I've been searching forums for help and there are some very close answers but nothing close enough. I'm trying to create a timesheet that takes into account multiple in and out times and uses decimals to denote time so 5am and 5pm both show as 5.00. The total hours should then be calculated out in quarter hours. I've provided an example below, in this instance the correct Total Hours for Friday would be 11.25, I just need a function that will help me get that. Any assistance would be great.

In | 5.00 |

Out | 10.00 |

In | 11.00 |

Out | 5.21 |

In | 0.00 |

Out | 0.00 |

In | 0.00 |

Out | 0.00 |

Total Hrs | 11.25 |

<colgroup><col><col></colgroup><tbody>

</tbody>

Last edited: