How to multiply time (hh:mm) for a constant on Excel?

Asked Jan 02 '20 at 18:33

Active Jan 02 '20 at 18:46

Viewed 145 times

I'm using WPF Office (but formulas is equal from Excel) and I want multiply time for constant. My goal is calculate the number of days for time worked. The work time is 8h 48min. So if I work 3 day, how time I've worked?

How I do it?

I'm trying do = E4 * (8.48/60) but not works, don't solve to result that I hope.

edited Jan 02 '20 at 18:41

asked Jan 02 '20 at 18:33

Augusto

3,825
9
45
93

`/24` not `/60` – Scott Craner Jan 02 '20 at 18:35
How are you getting `8.48`? – BigBen Jan 02 '20 at 18:37
`=(E4*8,48)/24` = 16:57. The correct anwser should be 17:36. – Augusto Jan 02 '20 at 18:37
@BigBen this is the work time. – Augusto Jan 02 '20 at 18:37
Oh so `8.48` is not `8:15`? – BigBen Jan 02 '20 at 18:38
@BigBen are examples, two different examples. – Augusto Jan 02 '20 at 18:38
Is the `.48` the number of minutes? – Scott Craner Jan 02 '20 at 18:39
@ScottCraner yes. – Augusto Jan 02 '20 at 18:39
is the value `8:48` or `8.48`? the difference is subtle, but important – cybernetic.nomad Jan 02 '20 at 19:12
Is it 8hrs 48mins of work each day for three days? – PeterT Jan 02 '20 at 19:58
So... after seeing the semicolon in the "correct answer", I am going to go with use `(Hour(E4)*60+Minute(E4))` would give you the # minutes worked. The two important functions, to specify each portion of your time are `Hour()` and `Minute()`. From there, you can divide as needed. – Cyril Jan 02 '20 at 20:48

How to multiply time (hh:mm) for a constant on Excel?

0 Answers0