Convert Time to Days

[Dzoker]

Hi there,

I need to convert 81:30 hrs to 10 days & 06:30 hrs. All formulas work
as 1day=24:00hrs....but I need 1day=07:30hrs..What I'm doing is time
sheet for my CompTime and i need to calculate - total CompTime Hrs =
How many working days...1working day = 07:30Hrs...

How can I do this...Any idea..Please help!!!


Thanks in advance,
D.

 

[T. Valko]

Try this:

A1 = 81:30
B1 = 7:30

=INT(A1/B1)+A1-INT(A1/B1)*B1

This will return a numeric value that can be formatted as custom d h:m

Note that this custom format will only work for up to 31 days. If you will
exceed 31 days then you'd either have to split the results into 2 cells
(days in 1 cell, time in 1 cell) or modify the formula to return a text
string.