calculating amount of hours in excel

[builder22]

this is for a timesheet...

I have a start time in one cell, finish time in another
because it's the 24hr clock finish time - start time gives the hours worked

so start at 10:00 finish at 18:45, 18:45 - 10:00 when the cells are formatted to time gives 08:45
8hrs 45mins is right but it's just 845am in excel

how do I make it show 8.75? is that even possible?

 

[izzop]

Hi,

Use the MROUND function as per my example below: -

=(MROUND(B2-A2,15/1440)*24)

Regards

 

[builder22]

Thanks very much, will do this when I get home

What does mround do?

I get 1440 is mins in a day, but why 15?

It's not too important for me to know tbh, just wondering

 

[zola25]

15/1440 will round to the nearest quarter hour.